Cumulated Sum with multiple Categories

[JANSAN]

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 categories it does not work. 

Bruch (kg) = SUM('Unpivoted Bruch '[AnzahlBruch(kg)])

Cumulative Total = 
VAR cumulativbruch = [Bruch (kg)]
RETURN 
CALCULATE(  
    [Bruch (kg)],
    FILTER(
        ALLSELECTED('Unpivoted Bruch '[Materialkurztext], 'Unpivoted Bruch '[BruchType] ),
        [Bruch (kg)] >= cumulativbruch
    )
)

My cumulation should be sorted by : 

'Unpivoted Bruch '[Materialkurztext], 'Unpivoted Bruch '[BruchType]

With 1 category 

Any help is appreciated!

[Anonymous]

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]

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......)

[JANSAN]

I updated the post, with 2 pics

[Mahesh0016]

@JANSAN Please can share your ENDOUTPUT in Table and Dummy Data For more understanding.THANK YOU!!