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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Tbourgoin
New Member

Create a filter based on multiple booleans ...

Hi, 

 

I'm trying to create a filter based on a Dynamics 365 entities with 7 booleans fields :

Traitement

 

I have my 7 columns with True or False depending of the record. But I don't know how to create a filter where i can one or more "Traitements" in a report. 

 

Thank for your help.

 

 

( Sorry for my english ^^ )

 

 

Tristab

 

 

 

1 REPLY 1
jshutters
Resolver I
Resolver I

Create a measure called ContainsTraitements, and use the IF function with all 7 of your boolean columns in the logical_test condition.  If any one of the boolean columns are true, then the entire measure will be set to true, otherwise false.  Finally, add this new measure to the visual level filter (or page or report level) and set it equal to 1.

For example...
ContainsTraitements = IF(Traitements1 || Traitements2 || Traitements3 ..., 1, 0)

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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