Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
lcfaria
Helper II
Helper II

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:

lcfaria_0-1707951616884.png

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:

lcfaria_1-1707951814450.png

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:

lcfaria_2-1707951903194.png

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

lcfaria_3-1707951929981.png

Since the data in my table is this:

lcfaria_4-1707952039031.png


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.

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

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

View solution in original post

2 REPLIES 2
lbendlin
Super User
Super User

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

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.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.