Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Cummulative sum in a column

Hi, 1) I have Grand Total column as below, from that i need to get % column value listed below. Grand Total 656,306 to get 30% i need to do  197,829/656,306 = 30% to get 13% i need to do 84,635/6...
DAX
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
3 years ago

Hi,

Please check the below picture and the attached pbix file.

 

 

Percentage measure: =
VAR _qty =
    SUM ( Data[Quantity] )
VAR _allqty =
    CALCULATE ( SUM ( Data[Quantity] ), REMOVEFILTERS () )
RETURN
    DIVIDE ( _qty, _allqty )

 

Cumulate percentage measure: =
VAR _qty =
    SUM ( Data[Quantity] )
VAR _cumulate =
    SUMX (
        FILTER ( ALL ( Data[Quantity] ), Data[Quantity] >= _qty ),
        [Percentage measure:]
    )
RETURN
    _cumulate

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thank you so much for the Quick Response
    Cumulative sum is not working for me 
    if you can see Percentage % and Cummative Percentage values both are same. 
    I have used the Measures which you shared. but values are same 
    Please help ?

     

    • Jihwan_Kim's avatar
      Jihwan_Kim
      Icon for Super User rankSuper User
      3 years ago

      Hi,

      Could you please share your sample pbix file's link here? And then I can try to look into it to come up with a more accurate solution.

      Thanks.

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Sorry i cant share the pbix file it has huge sensitive data. But i can share the screenshot of the measure which i am using.