Forum Discussion
How to integrate several depending parameter values most efficiently into one Measure?
- 3 years ago
The default way filters work is they are "stacked" on top of each other, as if you would say "AND". This is true for individual columns, for tables, and for the entire data model. For example Ordertype = GreenMachine AND Ordersubtype = RedPlate
What you seem to want is an "OR" filter where you append conditions like Ordertype = GreenMachine OR Ordersubtype = RedPlate
That is not something Power BI supports natively, you will have to implement that entirey through measures that you then use as visual filters.
The default way filters work is they are "stacked" on top of each other, as if you would say "AND". This is true for individual columns, for tables, and for the entire data model. For example Ordertype = GreenMachine AND Ordersubtype = RedPlate
What you seem to want is an "OR" filter where you append conditions like Ordertype = GreenMachine OR Ordersubtype = RedPlate
That is not something Power BI supports natively, you will have to implement that entirey through measures that you then use as visual filters.