Forum Discussion
Filters with OR capabilities
Hi,
I have two filters that I want to use the OR capabilities on. It seems as though OR exists as an option within 1 field, but cannot be used across multiple fields in the filter pane.
See example below:
| Name | Focus 1 |
| Amy | Gymnastics |
| Susan | Swimming |
| Tiffany | Dance |
| Name | Focus 2 |
| Jackson | Gymnastics |
| Bruce | Volleyball |
| Amanda | Soccer |
| John | Gymnastics |
| Megan | Dance |
What I'm looking for:
Filter where Focus 1 is Gymnastics OR where Focus 2 is Gymnastics
This should result in
Amy, Jackson, and John
Currently in the filter pane it seems like I can do Focus 1 contains Gymnastics OR contains Dance and it would result in Amy and Tiffany.
Is there a way I can use OR between two filters within the filter pane in BI?
2 Replies
Anonymous , Are these two table ?
Hi Anonymous
If the two tables have the same fields, you might consider merging them.
The following article can help you How to combine data.
https://docs.microsoft.com/en-us/power-query/append-queries
OR
You can use DAX to achieve the table
New table = UNION ( 'Table1', 'Table2' )Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
