C19 is a section that contains the C191, C192 and C193 divisions, and the C191 division contains a group called 411, C192 contains a group called 412 and C193 contains two groups - 283 and 413. I am trying to get the row maximum at the higher hierarchical level as well. However Power BI is showing the maximum values for the group level at the section level as well. How do I solve this problem ?
a screenshot of the data to recreate the situation:
Thanks