Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Filter based on selected user's region

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 pers...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    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.

v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
4 years ago

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's avatar
    Anonymous
    Not applicable
    4 years ago

    This works. Thanks!