Forum Discussion
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 : I have my 7 columns with True or False depending of the record. But I don't know how to create...
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)