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 across all groups

If all Level 2(BU) checkboxes selected, display sum of Level 1(Group) total across all group

If not all Level 3 checkboxes selcted (regardless of BU), display selected Level 3 (Division) total across all BUs

If not all Level 2 checkboxes selcted (regardless of Group), display selected Level 2 (BU)total across all groups.

Below are some examples:

If Audit, SPU, YAD selected, display sum of (Audit, SPU, YAD)

If 7JB and F8C selected, display sum of (7jb and f8c)

If OC9 selected and Audit selected, display sum of (DIM, TIF and Audit)

Need Help

4 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community 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

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Maggie I'm not sure if you read my post fully. Look at the example and the slicing selection. I know how to do a basic agg based on slicer selection. This is more complex.  There are three totals (Group, BU and Division)  I have gotten other feedback and I was able to get part of the solution working. Below are some examples:

       

      1.  If Audit, SPU, YAD selected, display sum of (Audit, SPU, YAD) (Division Total)

      2.  If 7JB and F8C selected, display sum of (7jb and f8c) - BU Total value (Note** This is NOT the sum of all children under that BU)

      3.  If OC9 selected and Audit selected, display sum of (DIM, TIF and Audit)