Forum Discussion

Krcmajster's avatar
Krcmajster
Helper IV
6 years ago

Multiselect filter as DAX

Hi All,    I have 2 tables, they don't have a relationship but have unique identifiers and I would still like them to "work together", meaning I want visuals to be filtered if values are selected o...
Need Help
v-yuta-msft's avatar
v-yuta-msft
Community Support
6 years ago

Krcmajster ,

 

You may modify the measure like below:

Result =
IF ( VALUES ( Table1[ID] ) IN VALUES ( Table2[ID] ), "Include", "Exclude" )

Result =
IF ( VALUES ( Table1[ID] ) IN FILTERS ( Table2[ID] ), "Include", "Exclude" )

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.