The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I have the following measure, in which my goal is to calculate [Total Sales] with the filter 'Dim Table'[Col] between 2 values:
Total Sales Filtered =
CALCULATE(
[Total Sales]
,'Dim Table'[Col] >= 1
,'Dim Table'[Col] <= 5
)
As far as I know, this is equivalent to:
Total Sales Filtered =
CALCULATE(
[Total Sales]
,FILTER(
ALL('Dim Table'[Col]
,'Dim Table'[Col] >= 1
&& 'Dim Table'[Col] <= 5
)
)
Are these two implementations of the measure actually equivalent? If so, is there a preference for one over the other? I ask because, for the situation of filtering between 2 values, I have only ever seen the second one, not the first one, even though the first one seems like it would be more common (since it's syntactical sugar).
Solved! Go to Solution.
Hey @Anonymous ,
from the way the engine works they should be equivalent. The different filter arguments are combined with a logical "and".
To be honest the first way is very uncommon to write it and if you're not deep into the DAX language it's difficult to understand. So for maintainability I would never write it like the first version.
Since March 2021 you can also combine the conditions. So my preferred way would be:
Total Sales Filtered =
CALCULATE(
[Total Sales],
'Dim Table'[Col] >= 1 && 'Dim Table'[Col] <= 5
)
Hey @Anonymous ,
from the way the engine works they should be equivalent. The different filter arguments are combined with a logical "and".
To be honest the first way is very uncommon to write it and if you're not deep into the DAX language it's difficult to understand. So for maintainability I would never write it like the first version.
Since March 2021 you can also combine the conditions. So my preferred way would be:
Total Sales Filtered =
CALCULATE(
[Total Sales],
'Dim Table'[Col] >= 1 && 'Dim Table'[Col] <= 5
)
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
79 | |
71 | |
48 | |
41 |
User | Count |
---|---|
138 | |
108 | |
71 | |
64 | |
58 |