Column value change based on matrix hierarchy

[sec4zj]

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 Chain	MTD	YTD	Target
GSC	76.7%	76.7%	75.9%
PSM	79.5%	79.5%	76.9%

And then the drill down looks like this: 

Product	Site	MTD	YTD	Target
GSC
A	RV	100.0%	100.0%	70.0%
A	UM	50.0%	50.0%	75.0%
A	BC	72.4%	72.4%	70.0%
PSM
P	BC	55.6%	55.6%	70.0%
P	W	47.6%	47,6%	70.0%
P	I	53.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.

[amitchandak]

@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