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

Anonymous's avatar
Anonymous
Not applicable
9 years ago

BKnecht I don't think there is a file upload option here. You'll have to put it on dropbox or google drive or something and give us a link.

  • v-haibl-msft's avatar
    v-haibl-msft
    Microsoft Employee
    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

    • BKnecht's avatar
      BKnecht
      Kudo Kingpin
      9 years ago

      That is so much easier than what I was trying to do, and it works perfectly. Have never created a table with that funciton before. Thank you Herbert - you saved me from updating another File every month. Very much appreciated!