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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

DAX Measure in Dynamic Matrix of Field Parameters

Hello, 
I have a matrix visual where the rows are field parameter values, which come from product attributes in a sales table. This allows the user to select the attributes in a separate slicer to create their own hierarchy. The matrix columns are aggregation measures, such as total sales. This is working well, but I had a request to add penetration, so the user can see a subcategory's share of its parent category. I've read online many ways to do this for static hierarchies, but not for dynamic ones. 

These two screenshots show my attempts to create a penetration measure for the sample Sales & Returns dataset. As you can see, the measure works when the user creates a Category -> Price hierarchy, but not if they select Price -> Category. My confidential data has a dozen product attributes, so I would prefer a general solution for all possible hierarchies.

 

Category - Price MatrixCategory - Price MatrixPrice - Category MatrixPrice - Category Matrix

You can download the sample data with my measures here.

1 REPLY 1
lbendlin
Super User
Super User

link requires login - please check.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors