Forum Discussion

JANSAN's avatar
JANSAN
Frequent Visitor
3 years ago

Cumulated Sum with multiple Categories

Hello; I want to create a table in which a measure is being cumulated. The Measure should be summed up by two categories. Having one category for the cumulation works, however if I use two categorie...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi  JANSAN ,

 

You can consider creating an Index to act as a top and bottom order for accumulation

Here are the steps you can follow：

1. In Power Query -- Add Column – Index Column – From 1.

2. Create measure.

Cumulative Total =
SUMX(
    FILTER(ALL('Unpivoted Bruch'),
    'Unpivoted Bruch'[Materialkurztext]=MAX('Unpivoted Bruch'[Materialkurztext])&&'Unpivoted Bruch'[BruchType]=MAX('Unpivoted Bruch'[BruchType])&&'Unpivoted Bruch'[Index]<=MAX('Unpivoted Bruch'[Index])),
    [AnzahlBruch(kg)])

3. Result:

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

JANSAN's avatar
JANSAN
Frequent Visitor
3 years ago

Your cumulation only works for one type of combined category (own cumulation for A1, for A2, A3....)
However I want to cumulate everything. So it should show the highest value first and then cumulate the number from there. So in your example data it should be (9+8+8+7+5......)