SELECTEDVALUE to filter OR clause

[TomaszKlakla]

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

[rrm121812]

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.

[rrm121812]

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.

[TomaszKlakla]

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