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
-
This video explains how to navigate the lattice of visual calculations in DAX. The visual context goes beyond the row context and filter context by adding the concept of levels within the lattice. The video shows how to use COLLAPSEALL… Watch now
-
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
-
We released a new session in SQLBI+: How to navigate the lattice of visual calculations: This video explains how to navigate the lattice of visual calculations in DAX, using COLLAPSEALL and EXPAND to move between levels. A key topic is… Read more
-
We released a new course for SQLBI+ subscribers: Understanding Visual Calculations in DAX. This is not an introduction to visual calculations for users. The goal is to explain the details of implementing visual calculations for experienced DAX developers, including new… Read more
-
Visual calculations are a new feature in DAX that aims to simplify the use of DAX for users by introducing calculations at the visual level rather than at the model level. 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
-
How to easily implement conditional formatting through visual calculations in Power BI. Watch now
