topic Re: SELECTEDVALUE to filter OR clause in DAX Commands and Tips

SELECTEDVALUE to filter OR clause

TomaszKlakla — Wed, 23 Aug 2023 08:59:46 GMT

Hi, I have a problem with OR clause and SELECTEDVALUE function, in that case I would like select by condition:
one Month, and by one Symbol OR Common is True:

Filtered = IF(OR('DataTable'[Symbol]=[SelectedSymbol],'DataTable'[Common]=TRUE()),TRUE(),FALSE())

example file

Re: SELECTEDVALUE to filter OR clause

rrm121812 — Wed, 23 Aug 2023 12:36:47 GMT

Hi,

You can write measure instead of a custom column as below:

The selected values of Month will show correct values of Filtered. However, you may need to remove the relationship between tables - Month and DataTable if you want entire column to be populated irrespective of filter applied.

Please Accept this answer as a solution if it works for you.

Re: SELECTEDVALUE to filter OR clause

TomaszKlakla — Wed, 23 Aug 2023 15:21:00 GMT

Sorry but this not working:
file with your measure
FilteredM doesn't change dynamically 😞

Re: SELECTEDVALUE to filter OR clause

rrm121812 — Thu, 24 Aug 2023 04:37:47 GMT

Hi TomaszKlakla,

When you say filter does not change dynamically, I am assuming when you select a particular value in Symbol Slicer, the table should display correspong TRUE/FALSE. Please let me know if you are looking for some other functionality.

In addition to the new measure, I have set the interaction between Slicer - Month and Table to none.

1. Select Month Slicer. Go to Format --> Edit Interaction and set the interaction to none.

SelectedValueOR.pbix

Hope this helps.