cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sec4zj
Frequent Visitor

Column value change based on matrix hierarchy

Hello, 

I have a matrix visualization that utilizes a hierarchy. I also have a target value that changes based on the hierarchy. What DAX should I use so that the value changes in accordance with the hierarchy? 

 

The top line visual looks like this: 

 

 Supply ChainMTDYTDTarget
GSC76.7%76.7%75.9%
PSM79.5%79.5%76.9%

 

And then the drill down looks like this: 

ProductSiteMTDYTDTarget
GSC    
ARV100.0%100.0%70.0%
AUM50.0%50.0%75.0%
ABC72.4%72.4%70.0%
PSM    
PBC55.6%55.6%70.0%
PW47.6%47,6%70.0%
PI53.3%53.3%70.0%

 

Note that the target for each supply chain has one value, and then those targets change again depending on the combination of product and site. Ideally, I'd be able to conditionally format the MTD value depending on whether it was more or less than the target.

1 REPLY 1
amitchandak
Super User
Super User

@sec4zj , You need to consider the calculation group for the same

 

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors
Top Kudoed Authors