Slicer using tags with and logic

[Anonymous]

I have data from multiple clients to display in a dashboard. Each client has data in the fact table and recrods in a dim table that correspond to tags for each client, ie non profit, related to animals, candidates etc. Clients can have multiple tags. I am trying to use a slicer that contains these tags to filter my data to clients with those tags, but I want to only include clients with all tags selected, not clients with at least one selected. How can I make this happen? This seems like it should be easy, but any solution I have found does not match this case. 

[v-angzheng-msft · Accepted solution]

Hi, @Anonymous 

So what you want is an "And" slicer.
Check out my solution in the thread below, it's definitely what you want.
AND filter or Slicer visual

More:
Category Combination Purchase

Best Regards,
Community Support Team _ Zeon Zheng

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

[amitchandak]

@Anonymous , You have try a measure like, If Tag are in different rows

new measure =
var _tag = countx(allselected(clinet), client[Tag])
return
countx(filter( summarize(client, Client[Client], "_1",count(client[Tag]) ) , [_1] =[_tag]), [client])

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.