Forum Discussion
Solved
Filter multiple values from different columns
Hi, I'm trying to filter my results where the value of column A is "yes" or the value of column B is "yes". Can someone help with the query? Edit: It's a view back to a database and won't let...
Hi scottjl ,
This is the data I created:
Here are the steps you can follow：
1. Create measure.
Measure = IF( MAX('Table'[priority])="Yes"||MAX('Table'[resources])="Yes",1,0)Result:
Now it shows that all data exist. Measure marks the unqualified data as 0 and the qualified data as 1
2. Put measure into filter, set is = 1, and apply filter
3. Result:
Display the data that meet the requirements:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This is not possible from the filter pane. You might want to create a calculated column as OR([Column A]="yes",[Column B]="yes") and then filter on the calculated column