Forum Discussion
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 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.
1 Reply
Anonymous , 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
