cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Post Partisan

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!

Super User

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.

Proud to be a Super User!

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.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors