Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I'm trying to create a filter based on a Dynamics 365 entities with 7 booleans fields :
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
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)
User | Count |
---|---|
139 | |
113 | |
103 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |