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

Anonymous yeah But the chart won't react for the Month filter. I need to filter that chart by unpivoted colum(Month), thats why I wanted the unpivoting. 

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

Anonymous

 

Please try the solution provided by KHorseman. If it still not works, please provide the sample table which includes Assignment Category and Type of Assignment.

 

Best Regards,

Herbert