Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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