Cumulative Total Measure doesnt consider duplicates

[JANSAN]

Hello,
I have 2 measures: 

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

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

The second measure cumulatitve total should give the cumulated values of Bruch(kg). This works mostly, however it doesnt consider duplicates of Bruch(kg).

Example: Bruch(kg) = 100+50+50+20
Cumulativ total = 100+150+150+170

Hope someone can helpe me 🙂

[VilmarSch]

Seria bom que enviasse uma amostra dos seus dados. Pode ser fictícios.

Se for como este, terá que incluir um índice

Acc = 
CALCULATE (
    SUM ( Tabela[Valor] ),
    FILTER (
        ALL ( Tabela[Índice], Tabela[Coluna] ),
        [Índice] <= MAX ( Tabela[Índice] )
    )
)

[v-jingzhang]

Hi @JANSAN 

Can you share some sample data of the table 'Unpivoted Brunch' along with some expected result based on that? Does column [Material_Bruch] have duplicated values?

Best Regards,
Community Support Team _ Jing

[JANSAN]

Unfortunaly I can not provide sample data. However yes [Material_Bruch] does have duplicates. Meaning in my data set, there are multiple AnzahlBruch(kg) which are associated with multiple [Material_bruch]. 

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

Bruch[kg] is a SUM of multiple AnzahlBruch(kg) (data entries). 

Material_bruch is being used as a category to sort the Sum of data entries. 

Hope that helps!

[pratyashasamal]

Hi @JANSAN ,
Try this once :-

Cumulative Total = 
VAR cumulativbruch = [Bruch (kg)]
RETURN
    CALCULATE (
        [Bruch (kg)],
        [Bruch (kg)] >= cumulativbruch,
        ALL ( 'Unpivoted Bruch'[Material_Bruch] )
    )
)

Thanks,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

[JANSAN]

Error : A function 'PLACEHOLDER' has been used in a True/False expression that is used as a table filter expression. This is not allowed.