Forum Discussion
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 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
3 Replies
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
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
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.
