Forum Discussion
Slicer matrix table
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.
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.
9 Replies
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.
Is it a bug?
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 !!!
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.
