Topic: DAX
-
SUMMARIZE is a very powerful and very complex function to use. This article describes its internal behavior, and provides guidance on how to use it. Read more
-
This article describes how to use KEEPFILTERS in DAX iterator functions to preserve arbitrarily shaped filters in context transition. Read more
-
Follow the process of optimizing a measure created in a previous unplugged to display the distribution of the distance between transactions in a column chart. Many people who have seen the previous unplugged asked for this second episode to discover… Watch now
-
Past are days of creating data models with a single monolithic tool provided by Microsoft. The required toolbelt includes multiple tools. Most of them are free and open-source. Watch the recording of the SQLBI live event delivered on Wednesday May… Read more
-
Alberto shares his exploration of different techniques for an article about displaying blank as zero in a DAX measure. The article and its video will be much shorter without the trial and error process that you can see without editing… Watch now
-
This article shows how to compute a measure that sums the values produced row by row in the visual into the visual total, instead of recomputing the total value in the filter context of the total. Read more
-
In this article we demonstrate how to use calculation groups to show the behavior of any measure in the last 6 months, starting from a single date selection with a slicer. This can be applied to any number of months. Read more
-
Why the standard DAX time intelligence functions might return unexpected results? Discover how DATEADD and SAMEPERIODLASTYEAR work under the hood! Watch now
-
This article introduces the new DAX syntax (March 2021) to support CALCULATE filter predicates that reference multiple columns from the same table. Read more
-
How to enable cross filter visual behavior in Power BI when using a measure showing Top N and “Other” row? The question came up in a comment to the article https://www.sqlbi.com/articles/filtering-the-top-products-alongside-the-other-products-in-power-bi/ Watch the video to see how we study the… Watch now
