Topic: Visual calculations
-
Visual calculations can either improve or degrade the performance of a report. In this article, we outline how we ensure visual calculations have a positive impact on performance. Read more
-
This article describes how to apply different formatting rules at each level of a hierarchy (one rule at the year level, another at the quarter level, another at the month level) using ISINSCOPE in a measure or ISATLEVEL in a… Read more
-
Visual calculations can be used efficiently to format visuals. This article presents an interesting technique to highlight a row based solely on the maximum value in the last column. Read more
-
Should you use RANK or stick with RANKX? In which scenarios is one better than the other? This article provides an in-depth analysis to help readers make informed choices. Read more
-
Visual calculations are useful for performing calculations specific to a visual. Conditional formatting is a great example of this concept. In this article, we show how to easily implement conditional formatting through visual calculations. Read more
-
This article describes the use of visual calculations for a scenario where they may be particularly relevant: computing open orders at the end of a time period. Read more
-
This article explains the unique behavior of apply semantics: a new way of computing table expressions when multiple rows are selected in DAX window functions. Read more
-
This article provides examples of visual calculations where the use of EXPAND and COLLAPSE is required to obtain the correct result. Read more
-
This article introduces the two basic visual context navigation functions: EXPAND and COLLAPSE. Read more
-
This article introduces the VISUAL SHAPE clause, which defines a hierarchical structure for a table used in visual calculations. Read more