Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 19 | |
| 11 | |
| 9 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 35 | |
| 32 | |
| 20 | |
| 12 | |
| 10 |