DAX

This article shows how variables in DAX can impact the coding style, simplifying a step-by-step approach and improving the readability of your code. The ne

I recently wrote an article to described in more details the syntax of the IN operator in DAX , which is available in Power BI and in the CTP of the next re

Having read this question on the mdsn blogs , I investigated on the KEEPFILTERS function and, after having learned it, it is now time to write about it. Moreover, before start to write about it, I need to thank the dev team of SSAS and Marco Russo who

There is a video that walks you through the solution in depth, please find the video at the end of this post along with the completed solution. In this installment of the Problem, Design, Solution …

This article describes how to create a virtual relationship in DAX using the TREATAS function, which is more efficient than approaches based on INTERSECT or

Automatic cross filtering between columns of the same table or related tables is a very powerful feature of DAX. It allows a measure to eval...

This article describes how DAX resolves column and measure names in DAX, providing best practices to avoid conflicting names. A fundamental rule you should

Welcome back readers, to another chapter in the DAX Reanimator Series! The post I’ll be re-envisioning today is one I’m very excited about.

DAX Moving Averages measure controlled by slicer in Power BI, using what-if-parameters, GenerateSeries, and disconnected table.

This article describes how to create a table with a series of numbers in DAX by using the new GENERATESERIES function or through a workaround using CALENDAR

I got an interesting request this week, to improve the usability of the tabular model they wanted to filter the dimension table to only contain the rows that have data in the fact table. That way t…

I had a requirement where I had a measure that I wanted to be filtered if it’s value was selected then it must show the value. As well as if nothing is selected on the slicer then I also want…