Forum Discussion
Using more than 2 filters best practice
Hi barakm
You can add the same field to the filter pane multiple times. Depending on what behavior you want the filters to have, this may or may not work for your use case:
An alternative would be to add a calculated column (DAX or in Power Query) that checks for all the conditions you want, and returns True or False for each row in your data. Then you can use this calculated column as a filter. Here is how that would look like using DAX calculated columns:
in the if statement, || is the OR operator, && is the AND operator, and CONTAINSSTRING evaluates to True or False for each criteria.
I guess it might work as a measure as well, similar to SamWiseOwl's solution.I hope this helps!
Hi SamWiseOwl...
Thank you very much for your reply, this is nice perspective to do it
I tried this, and it worked but for exact match.
How do I change this for somthing that only contains these attributes ?
for example if I do "A" or "B" or "C" or "D" I wish it would match also values like "bananA" or "Dongle" or "sCaner"
Super UserHi barakm
You can add the same field to the filter pane multiple times. Depending on what behavior you want the filters to have, this may or may not work for your use case:
An alternative would be to add a calculated column (DAX or in Power Query) that checks for all the conditions you want, and returns True or False for each row in your data. Then you can use this calculated column as a filter. Here is how that would look like using DAX calculated columns:
in the if statement, || is the OR operator, && is the AND operator, and CONTAINSSTRING evaluates to True or False for each criteria.
I guess it might work as a measure as well, similar to SamWiseOwl's solution.
I hope this helps!