Forum Discussion
Filter on Multiple Fields
I have a user requirement where they want to filter on multiple fields using "OR" e.g. Filter on Cost Price > 500 or Sales Price > 600. This should basically return rows with Cost price >500 OR Sal...
You might have better luck creating two disconnected slicers from your table and then creating a measure that returns yes or no if the criteria is met.
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Hey Greg_Deckler
Can you elaborate as to how I can do this? I think the users will be okay if there is another measure which will give them a Yes or a NO based on the criteria.