Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
MarkEvansHW
Helper II
Helper II

Boolean Aggregate Functions?

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.

1 ACCEPTED SOLUTION
Fowmy
Super User
Super User

@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 🙂

YouTube  LinkedIn



 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

3 REPLIES 3
Fowmy
Super User
Super User

@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 🙂

YouTube  LinkedIn



 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Greg_Deckler
Community Champion
Community Champion

@MarkEvansHW  Yes, this works:

Measure 5 = IF(TRUE() IN SELECTCOLUMNS('Table (5)',"Column",[Column1]),TRUE(),FALSE())

PBIX is attached below sig 



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...
amitchandak
Super User
Super User

@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.

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.