Forum Discussion

lcfaria's avatar
lcfaria
Helper II
2 years ago
Solved

Dynamic Matrix - Selection from Slicers

Hello everyone, I need some help from the community.

 

I have a data model and I need to create a dynamic field in my matrix to bring the total number of records, based on the selection from my slicers.

 

What I have is this:
3 slicers with attrib. 1, attrib. 2 and attrib. 3.

1 matrix with a dynamic filter (I created a measure for this that you can see below) and the total of records.

PS: You can also find the pbix at the end of the post. 

 

My measure:

What happens is that this works very well if I have only a single selection in each slicer.
For example, if I select:
Attrib.1 = A1_Val2
Attrib.2 = A2_Val3
Attrib.3 = A3_Val1
This is my result and it's correct:

The problem I'm facing happens when I select more than 1 item in my slicers.
For example, if I select:
Attrib.1 = A1_Val2
Attrib.2 = A2_Val3
Attrib.3 = A3_Val1 and A3_Val3
This is the result I get, my selection for Attrib.3 disappears:

And I would like in this case my output to be this:

Since the data in my table is this:


Could someone help me with this?

 

This is the link to the PBIX file:
Sample_DynamicField.pbix

 

I appreciate the help from everyone in advance.

  • Have you considered using Field Parameters instead? They are designed exactly for this purpose, with little to no code needed.

2 Replies

  • Have you considered using Field Parameters instead? They are designed exactly for this purpose, with little to no code needed.

    • lcfaria's avatar
      lcfaria
      Helper II

      Hi lbendlin I had to make some adjustments because the field parameters alone didn't solve everything, but it was a good way to reach the solution. Thank you for the help.