Forum Discussion
DarrenLau
Advocate I
4 years agoFiltering a slicer (no relationship_
Hi, Looking for some help to see if this can be done. Conceptually, I need to filter a dimension table based on a selection on another dimension table. These two tables are unable to be linked to...
- 4 years ago
Thanks Jihwan_Kim
That would be an acceptable solution if I am trying to find salespeople with sales, the slicer should show users filtered by location.
I found the solution in another post and I have updated the PBIX - Filtering a slicer example
DAX used
Location Filters Users = IF ( MAX ( 'Salespeople'[Location] ) IN VALUES ( 'Sales Location'[SalesLocation] ), 1, 0 )