Forum Discussion

bo_afk's avatar
bo_afk
Icon for Post Patron rankPost Patron
5 years ago

Sum 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...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

bo_afk , Try like

 

Measure = CALCULATE(SUM('Table (2)'[Sales]), REMOVEFILTERS('Table (2)'[Category1],'Table (2)'[Category2]))

 

  • bo_afk's avatar
    bo_afk
    Icon for Post Patron rankPost Patron
    5 years ago

    Hi amitchandak, thanks for your suggestion. Unfortunately this hasnt completely worked. It sums it up by productID but not by category 2.