Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Restrictive multiple selection

Dear colleagues,   After looking for a solution without any success, I was wondering whether you could answer my question.   I have a matrix visual I want to filter its output by using a slicer t...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, Anonymous ;

    You could create a new table then create a flag measure.

    1.create a new table as slicer

    slicer = VALUES('Table'[cate])

     2.create a flag measure.

    flag = IF( CALCULATE(DISTINCTCOUNT('Table'[cate]),FILTER(ALL('Table'),[ID]=MAX('Table'[ID])))=DISTINCTCOUNT(slicer[cate]),1,0)

    3.apply the flag measure into filter

    The final output is shown below:

    Not sure you understand your logic correctly? If not, please correct me and provide more information.
    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.