Restrictive multiple selection

[Álvaro_SM]

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 that I placed on top of it.

The main problem I have is that whenever I select multiple values in the slicer, my table does not understand that I'm only looking for exact matches.

Just to give you an example, this is the current output when I select two skills (Python and SQL) from the slicer:

ID	Python	SQL
Emp_1	4	4
Emp_2		4
Emp_3	3
Emp_4	3	1

What I would like to get:

ID	Python	SQL
Emp_1	4	4
Emp_4	3	1

Is there any way to achieve this? In fact, I'm using a card visual to count and show the number of matches. As you will understand, it's performing as bad as my table.

Thank you!

[v-yalanwu-msft · Accepted solution]

Hi, @Álvaro_SM ;

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.

[Álvaro_SM]

Dear @v-yalanwu-msft ,

First of all, sorry for my late reply.

In fact, I tried to do it your way but still could not achieve my goal.

I wish I could share the pbix file, but this platform doesn't allow me somehow.

Please access my files (containing dummy data) through the link below: (as I cannot attach any here) 

https://filexchange.allianz.de/Download.aspx?id=c6101f8d-09cd-47a8-a370-87ff3a0b889c-8347cf7da758e05...

Thank you very much,

[Álvaro_SM]

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,

[amitchandak]

@Álvaro_SM , if you have taken slicer and selected values emp_14 and emp_43, t should give that, if the two visual are interacting.

Hope interactions is not off

https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions