Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 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
Anonymous's avatar
Anonymous
Not applicable
4 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
4 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
    4 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.

     

     

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

      Hi,

      I cannot know the column name in your visualization that is placed in the left side of it.

      Please try something like below.

      Cumulate percentage measure: =
VAR _percentage = [Percentage measure:]
VAR _cumulate =
    SUMX (
        FILTER (
            ALL ( 'TableName'[somethinglikeindexcolumn] ),
            [Percentage measure:] >= _percentage
        ),
        [Percentage measure:]
    )
RETURN
    _cumulate
      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hi,
        I am using the Country in left column of the visual