Forum Discussion

BKnecht's avatar
BKnecht
Kudo Kingpin
9 years ago
Solved

Sum Unique Rows after Unpivot

I have a table with unique rows. I had to unpivot the table based on a column to get a value I was looking for. The problem is, after I unpivot the table, all of the other measures I would try to mak...
  • v-haibl-msft's avatar
    v-haibl-msft
    9 years ago

    BKnecht

     

    I’m not sure the visual/table you want now. If you just want to count the # Seats column for each unique row based on the ID column. Just create a new table with following formula.

     

     

    Best Regards,

    Herbert

v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
9 years ago

BKnecht

 

We need to do unpivot in Query Editor, but the measure results cannot be used there. Unpivot will change the table structure, so the measure which created before unpivot will be affected. According to your description, maybe you can first try to use Power Query to get the expected result and then do unpivot in Query Editor as ChrisHaas said.

 

Best Regards,

Herbert