Nested Group By

[Anonymous]

Hello PowerBI experts,

I need some help with a situation.

I have a datasource that is looking like this.

 

I try to do a nested group by and have an output like :

Red

  Line 1

  Line 3

   total

Green

  Line1

  Line4

   total

Blue

 Line2

   total

Can you give me some hints how to accomplish this ?

Thank you.

[Anonymous · Accepted solution]

I find an workarround.

I did 3 copies of the querry.

To first I renamed column A to SalesPerson, to second I renamed column B to SalesPerson to third querry I renamed column C as SalesPerson.

Then I combined this 3 queries to one and I have a common column, SalesPerson.

Maybe there a better solution. Time to load data is increased with this method.

[Anonymous]

Solution what I found is to make 3 copies of the query source.

Unpivot each copy table bt column A, column B and column C to a common column SalesPerson and merge them after.

[v-yulgu-msft]

Hi @Anonymous,

I cannot understand your requirement very well. What does "Line1", "Line3" refer to? Could you please describe the desired output with more details? If possible, please show your desired result with an image.

Regards,

Yuliana Gu

[Anonymous]

I need a grouping by sales person.  But sales person can be on one of first 3 columns.

Sales person Red is on  first line and third line. and so on.

I think a method is to unpivot table.