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
It worked for a Card, only for showing the count. thnks alot. but If we need to show a count/or a sum of columns by a different data legand by a bar chart, it won't react. please find the attached pics. It works for a card.it wont work for this type of chart
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.