filters add data (OR condition) instead of excluding them (AND condition)

[MinaMvi24]

Is there a way in Power BI to have multiple independent filters, more than ten, where the condition works as follows?

For example, if the table looks like this:

| Col 1 | Col 2 | Col 3 |  
|-------|-------|-------|  
| $       | 1        | A      |  
| @      | 1        | B      |  
| &      | 2         | B     |  

- When I filter by Col 1 for the symbol '$', only the dollar symbol appears.
- When I filter by Col 2 for the number 2, both the dollar symbol ($) and ampersand (&) should show up.
- When I filter by Col 3 for 'A', the report should add information, and in this case, '@' will not be included in the final report.

Is there a way to achieve this behavior where filters add data (OR condition) instead of excluding them (AND condition)?

[lbendlin]

You need to use independent (disconnected) tables for each of your columns and measures to compute the OR condition.

[MinaMvi24]

Thank you @lbendlin 

is it something similar to this Solved: 2?  Solved: 2 independent slicers, one dataset - Microsoft Fabric Community
as it needs using conditional coding and if there are 20 filters the code will be more than 100 lines(10 lines for 2 filters and more than 100 lines for 20 filters) is it something practical?

[lbendlin]

Consider unpivoting these 100 columns into key/value pairs. That way you can do the OR filter inside a single column.