Multiselect filter as DAX

[Krcmajster]

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 on other visual or filters. It's fine if I use SELECTEDVALUES or VALUES and item is selected but I have a problem when multiple items are selected.

Example:

if(VALUES(Table1[ID])=VALUES(Table2[ID]),"Include","Exclude")

but this will throw error if multiple items are selected

[v-yuta-msft]

@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.

[Greg_Deckler]

Try using the IN operator and I would ditch the VALUES.

https://community.powerbi.com/t5/Community-Blog/Soapbox-Series-Adding-No-VALUE-S/ba-p/1059818

[Krcmajster]

@Greg_Deckler How you suggest to formulate the measure? It doesn't matter what the output (integer, string, boolean) is as long as it I can add it as a filter to a visual