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.
Is there any way to aggregate a boolean field so that the summary result with be TRUE if any of the detail rows are TRUE? Similarly, aggregate so that the summary result is TRUE if all of the detail rows are TRUE?
In postgresql and Redshift, these aggregating functions are named bool_or() and bool_and() - they are very handy at times. Does anyone know how to accomplish the same thing within Power BI? Thanks.
Solved! Go to Solution.
@MarkEvansHW
To check if any TRUE exists in a field use this measure:
AnyTRUE = CONTAINS(Table,Table[Column],TRUE())
To check if TRUE exists in all rows of a field, use this measure:
AllTRUE = NOT CONTAINS(Table,Table[Column],FALSE())
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@MarkEvansHW
To check if any TRUE exists in a field use this measure:
AnyTRUE = CONTAINS(Table,Table[Column],TRUE())
To check if TRUE exists in all rows of a field, use this measure:
AllTRUE = NOT CONTAINS(Table,Table[Column],FALSE())
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@MarkEvansHW Yes, this works:
Measure 5 = IF(TRUE() IN SELECTCOLUMNS('Table (5)',"Column",[Column1]),TRUE(),FALSE())
PBIX is attached below sig
@MarkEvansHW , Not very clear. But I doubt I noticed aggregating functions. Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
19 |