Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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
)
User | Count |
---|---|
117 | |
74 | |
62 | |
50 | |
45 |
User | Count |
---|---|
174 | |
125 | |
60 | |
60 | |
57 |