Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Display total value based on Hierarchy slicer selection

I have a hierarchy table and would like to display total based on what level the slicer is selected.     If all Level 3 (Division) checkboxes selected, display sum of Level 2 (BU) total acro...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

 

That being said, you might want to check out my Quick Measure, Matrix Measure Total Triple Threat Rock & Roll as it might give you some ideas on how to get what you are looking for:

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

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Greg

 

Thanks for the feedback.  I go tthe total to add up at the Group level havig issues keeping the total at the bottom levels.  I've updated the post with example and an updated screenshot of the report.

 

Any input would be appreciated.

 

Thanks