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
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 20 | |
| 10 | |
| 9 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 34 | |
| 31 | |
| 19 | |
| 12 | |
| 10 |