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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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