Forum Discussion
Helper IIIdifferent calculation on top level hierarchy
hi all,
I have a hierarchy like following, where group is the total level
Group
Continent
Country
Entity
I have some calculations where I need to do consolidation on Group level, this means that numbers are included in the lower levels but when we reach top level these numbers should be excluded from the total (group level)
I tried to do it with isinscope and isfiltered but have not yet manage to do it because when I filter the top level I automatically filter the lower levels. Can someone guide me to a solution for this?
BR Frank
2 Replies
- Ritaf1983
Super User
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
fjjpeeters1976hi, unfortunately due to confidentiality of the data and also because of the complexity of the model it is not possible for me to provide a power bi sample report. So my question is more a general one to guide me to the solution than that I would want a full fix already.
I would assume that my question is one that more people have faced where you need to show a different consolidated number on a higher level than what you show in lower hierarchies
BR
Frank
