Forum Discussion
Sum Unique Rows after Unpivot
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 the ALLEXCEPT function means that any other filtering context will be ignored except whatever columns are listed there. The formula from v-haibl-msft only lists the Month column. If you want to chart this against some other columns such as Category, you'll have to add those to the list.
Anonymous v-haibl-msft Yeah when I added those columns to the measure the chart will comes as expected. but it wont react for the Month Filter. The reason I unpivoted month columns is to add a filter by month. Please give me a solution. Thanks
Anonymous I gave you the solution . Add the caregory column to the ALLEXCEPT function. Right after the month column. Type a comma, a space, and the name of the category column. Hit Enter.
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.
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