cancel
Showing results for
Did you mean:
Frequent Visitor

## Cumulative Total Measure doesnt consider duplicates

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 🙂

5 REPLIES 5
Resolver I

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] )
)
)``````

Community Support

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

Frequent Visitor

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!

Solution Sage

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.

Frequent Visitor

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