Forum Discussion
bo_afk
Post Patron
Post PatronSum values by category in table
I've created a measure to sum my values grouped by 2 categories using the SUM and ALLEXCEPT functions, however it's not calculating the numbers as expected. Table Category2 Category1 ProductID...
Hello bo_afk ,
You better create column instead of measure and try,
Column = CALCULATE(SUM(Table[Sales]),ALLEXCEPT(Table,Sheet15[Category1],Table[Category2]))
bo_afkPost Patron
Post PatronHi Anonymous, thanks for the suggestion. This does seem to work however this doesn't dynamically calculate if I apply other filters in the report. Am I really unable to create this as a measure so that the figure changes with filters?