RankX in unbalanced parent-child hierarchy

[Bruin87]

Hi,

my goal is to show the ranking of a Tradelane within its parent entity.

The visual i got is 50% correct 🙂

Within the (level2) Road/Rail section all Tradelanes are ranked correctly.

However if you have a look on the other level 2 aggegration (Air/Ocean) the ranks are always 1. I don`t unterstand this behavior, as there is no special calculation for this part of level2.

The measures:

Would be great if anyone has a tip

Thanks in advance

Bruin87

[lbendlin · Accepted solution]

This is too complext to follow ( too many measure nesting levels)  but it feels like you should use ALLSELECTED() or ALLEXCEPT() here instead of ALL()

Please provide sanitized sample data that fully covers your issue.