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.
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)
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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |