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.
Hi
I would like to add a column/measure 'All True' which is TRUE when the 'Check' is TRUE for all rows with the same 'Name' - otherwise it should be FALSE.
Tried some other solutions from this community, but without any luck. Thanks in advance!
Example - the column 'All True' is the one generated by the DAX measure:
Time | Name | Check | All True |
9:00:00 | John | TRUE | FALSE |
9:15:00 | John | FALSE | FALSE |
9:30:00 | John | TRUE | FALSE |
9:45:00 | John | TRUE | FALSE |
9:00:00 | Bob | TRUE | TRUE |
9:15:00 | Bob | TRUE | TRUE |
9:30:00 | Bob | TRUE | TRUE |
9:45:00 | Bob | TRUE | TRUE |
Solved! Go to Solution.
All True =
ISEMPTY(
FILTER( INFO, INFO[Name] = EARLIER( INFO[Name] )
&& INFO[Check] = FALSE() )
)
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
All True =
ISEMPTY(
FILTER( INFO, INFO[Name] = EARLIER( INFO[Name] )
&& INFO[Check] = FALSE() )
)
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Hi @Anonymous .
Is the 'All True' column the output you need?
Yes, exactly
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 |
---|---|
39 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
44 | |
32 | |
30 | |
18 | |
17 |