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)], ...
Need Help
v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity 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!