detailed totals for hierarchy in a matrix

[Anonymous]

I have a situation where I have a 2-level hierarchy

Channel

      Sub Channel

On the report I show

Channel                                        Actual   Pct to Plan       YoY

     Sub-Channel 1

                  Sales Type 1

                  Sales Type 2

                  Sales Type 3

                  PCT to measure

Sub-Channel 2

                  Sales Type 1

                  Sales Type 2

                  Sales Type 3

                  Pct to measure

Is there a way to have the Channel (Higher level) to get the grid to look like this. I standard total doesn't make sense since Sales Type 2 Actual is a subset of Sales Type 1 and Sales Type 3 is a different measure all together.

The users want something like this where Channel is the sum of any and all sub channels. Need to do this in a single visual instead of "stacking" (for export)

[v-piga-msft]

Hi @Anonymous ,

Have you solved your problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please share your data sample as table format so that I could have a test on it.

Best Regards,

Cherry

[Anonymous]

Was not what I was looking for. I need "detail" rows at the higher level at the same time as the "Lower" level rows in the hierarchy. Where Parent Metric 1 = Child 1 Metric 1 + Child 2 Metric 1 , etc.

Parent

     Metric 1

     Metric 2

    Metric 3

       Child 1

             Metric 1

             Metric 2

             Metric 3

[Greg_Deckler]

See if this helps:

Matrix Measure Total Triple Threat Rock & Roll

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