Forum Discussion

JANSAN's avatar
JANSAN
Frequent Visitor
3 years ago

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 🙂

Need Help

5 Replies

  • pratyashasamal's avatar
    pratyashasamal
    Memorable Member
    3 years ago

    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's avatar
      JANSAN
      Frequent Visitor
      3 years ago

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

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    3 years ago

    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's avatar
      JANSAN
      Frequent Visitor
      3 years ago

      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!




  • VilmarSch's avatar
    VilmarSch
    Post Partisan
    3 years ago

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