Filter based on selected user's region

[Anonymous]

Hello Everyone,

I have a slicer in which I can select a specific sales person and there's a table with general information of their assigned accounts. My goal is that when i select one sales person, it'll list me all assigned accounts from the sales person's region. This is because a region may have assigned sales people the are no longer active. 

The below video almost got the job done but the issue is that one user can have multiple regions. Is there a way to auto select all once the chicklet slicer gets updated? Is there a different way to tackle this issue?

https://www.youtube.com/watch?v=-kOvK7IV3sg&t=3s 

[v-yalanwu-msft · Accepted solution]

Hi, @Anonymous ;

You could add another table about user's name as a slicer.

slicer = VALUES('Table'[Name])

Then create a flag masure.

flag = IF(MAX('Table'[Location]) in  SUMMARIZE(FILTER(ALL('Table'),[Name] in ALLSELECTED(slicer[Name])),'Table'[Location]),1,0)

Apply it into filter.

The final show:

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

This works. Thanks!

[ghoshabhijeet]

@Anonymous  Would you be able to share a sample PBIX file? Thanks !