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.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi amitchandak,

 

I'm sorry, just realized the table isn't somehow reflecting what I typed in...

 

The current output looks like this:

                  Python     SQL

Emp_1            4            4

Emp_2                          4

Emp_3            3

Emp_4            3            1

 

Therefore, my desired output is:

                 Python   SQL

Emp_1           4          4

Emp_4           3          1

 

Looking at interactions was the very first thing I did. It's very weird since I switched off the other slicers andd this slicer is actively filtering the table (not highlighting).

 

I believe the issue lies in the fact that my slicer allows for multiple selection, but doesn't perform an inner join.

 

Thank you,