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

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

    Anonymous

     

    Actually it can be filtered by Month with current formula. We cannot see any difference by selecting different months in slicer, because there are always three Operational, one Financial and one IT in each month. So we always get 3-1-1 no matter we select any month. If you add Time column into Value field, we can see the changes.

     

     

     

    Best Regards,

    Herbert

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    v-haibl-msft It didn't work. I've uploaded the sample excel and the BI file. Please go through the following link. I need to filter by both month column( appear after unpivoting) and the Assignment category column. Please help. 

     

    https://drive.google.com/open?id=0B8t7sq0ueJftSGJ2TFJUeElhNzA

     

     

     

    Thanks and regards,

    Dinu

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    v-haibl-msft yeah it's working. I've had selected the wrong column. Sorry for bothering you. Thnaks alot for the DAX v-haibl-msft. You saved me :)