Topic: DAX
-
Convert a “Top N and others” measure pattern into a calculation group that can be applied to any DAX measure in a Power BI model. Watch now
-
How to modify the basket analysis measure to compute the Sales Amount of orders that have both products selected? This unplugged video show how we analyze the problem and write the formula, testing the result and refining the code so… Watch now
-
DAX Studio 2.16 has two new preview features: Show Debug Commas and Show XMLA Commands. With Show Debug Commas you enable a button to move commas from the end of a line to the beginning of the following line, which… Watch now
-
How to force a measure to return zero instead of blank, in order to highlight combinations of attributes with no data. Watch now
-
Alberto answers a user comment asking how to hide calculation items when too many of them are selected in a report. Explore how we analyze the problem and find possible solutions. Watch now
-
Explore how to create custom groups based on a slicer selection in Power BI. For example, create two versions of a measure: one returns the value of the selected items, and another one returns the value of the other items,… Watch now
-
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
-
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
-
Why the standard DAX time intelligence functions might return unexpected results? Discover how DATEADD and SAMEPERIODLASTYEAR work under the hood! Watch now
-
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
