Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am using two DAX measures; Measure 1 works fine. Measure 2 shows the same aggregate as Measure 1. However, Measure 2 displays the correct values in a table (except for the total).
I'm guessing I did not set the filter ideally, or have a problem filtering on the result?
Measure1 = CALCULATE(DISTINCTCOUNT('Table'[ID]), 'Table'[Summary] <> "X")
Measure2 = CALCULATE(DISTINCTCOUNT('Table'[ID]), 'Table'[Summary] <> "X", FILTER('Table', COUNT('Table'[ID]) > 1))
Solved! Go to Solution.
Mate, would you mind posting some kind of screenshot of what the issue is you're talking about? Why do you want these two measures to return the same values?
By the way, using
filter( 'Table', COUNT( Table[ID] ) > 1 )
executes COUNT(...) without context transition and - depending on what you have in the Table - it does not filter anything or filters out everything. But why the two measures return different values I can't tell since I can't see where and how they're being used.
Best
Darek
Please paste some screenshots of your model and tell us what you want Measure2 to do... It's not clear what you want it to do at this point. If you can, please give us a CLEAR explanation of how the measure should work.
Thanks.
Best
Darek
Mate, would you mind posting some kind of screenshot of what the issue is you're talking about? Why do you want these two measures to return the same values?
By the way, using
filter( 'Table', COUNT( Table[ID] ) > 1 )
executes COUNT(...) without context transition and - depending on what you have in the Table - it does not filter anything or filters out everything. But why the two measures return different values I can't tell since I can't see where and how they're being used.
Best
Darek
They are supposed to return different results. They do on a data level, but not on a total level.
How would you reccomend I do the context transition?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
36 | |
33 | |
18 | |
18 |