Forum Discussion

freginier's avatar
freginier
Icon for Solution Sage rankSolution Sage
4 years ago
Solved

Repeat result sum on all rows

Hi all,    I have this kind of table : Category Project Amount CAT1 Project1 10 CAT1 Project2 20 CAT2 Project3 30 CAT3 Project4 40 CAT3 Project5 50   I want ...
  • PaulDBrown's avatar
    4 years ago

    Use this measure:

    CAT3 value = CALCULATE (SUM(Table[Amount]), Table[Category] = "CAT3")