Calculate different figures in Matrix based on displayed hierarchy level using DAX

[MartinM]

Hi guys,

Have someone of You realized issue how to calculate different figures for each level of hierarchy? I dont know how to show one figures (I have already calculated) for the lowest level of hierarchy and another for higher level while number of levels are not fix. I have database like this

And I need to show for users only one value in Matrix and should looks like this:

But I am not able to show / calculate different figures for each levels => in case for example A2.1.1 or B1.1 is last level in hierarchy should include only values for posting items 1 and in case its not last lavel in hierarchy should include all values with all posting levels.

Thanks

[Greg_Deckler]

Check out Matrix Measure Total Triple Threat Rock & Roll.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Matrix-Measure-Total-Triple-Threat-Rock-amp-...

[MartinM]

Hi,

This is working only if You have fix hierarchy and each level are fulfilled but I dont have fix hierarchy and some companies going up to level 6 and some only to level 4.

Think I find solution but I need to test it and I will let know the result soon.

Thanks a lot