Slicer matrix table

[koorosh]

Hello, please check the following image. On the left matrix, the slicer took from partner from Partner table, and on the right matrix, slicer took from partner from sheet1 table. As you see the result is not the same.?!

Since I would have other tables on the report that has relation with the Partner table, I just need to filter the matrix by the partner in the Partner table.

[v-janeyg-msft · Accepted solution]

Hi, @koorosh 

In fact, you can find that the number of "✅" is corresponding and correct. It's just that the number of "❌" has increased, because the function you wrote also contains blank values(When not selected), which needs to be excluded. And It doesn't need to change the relationship.

Like this:

Measure = 
IF(SELECTEDVALUE(Sheet1[Value])=BLANK(),BLANK(),IF(SELECTEDVALUE(Sheet1[Value]) = "T" ,"✅" ,"❌"))

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[koorosh]

I found the problem appeared when we use measure in the matrix. If we use value in the matrix the slicer acts correctly, but when we use measure in the matrix slicer does not work on it !!!

[koorosh]

Is it a bug?

[amitchandak]

@koorosh , hope these table and partner tables are joined and having 1 -M relationship.

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[koorosh]

I found the problem appeared when we use measure in the matrix. If we use value in the matrix the slicer acts correctly, but when we use measure in the matrix slicer does not work on it !!!

[koorosh]

Yes, have 1-M relationship.

Are above enough Amit?

[koorosh]

[amitchandak]

@koorosh , if name and service are from Sheet one, it should be filtered in the same manner.

Can you a sample pbix after removing sensitive data.

[koorosh]

What do you mean removing sensitive data ?

https://drive.google.com/file/d/1RGJR8A3rR0xUi3Pst7GeiTDKjoSnS3hn/view?usp=sharing