Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Cumulative %

Hi   Can someone please help me to achieve the "cumulative %" measure based on the current displayed data. If possible please attached the Dax Code with an example.       Also please adv...
Need Help
  • lbendlin's avatar
    lbendlin
    4 years ago
    Cumul % = 
var cr = sum('Sales Table'[Qty])
var s = summarize(allselected('Sales Table'),'Sales Table'[Store],"q",sum('Sales Table'[Qty]))
var t = filter(s,[q]>=cr)
return divide(sumx(t,[q]),sumx(s,[q]))

     

    Note that you have ties in your data so the result is a bit ugly.

lbendlin's avatar
lbendlin
Super User
4 years ago

Please provide sanitized sample data that fully covers your issue. I cannot help you without usable sample data.
Please paste the data into a table in your post or use one of the file services like OneDrive or Google Drive. I cannot use screenshots of your source data.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Dear Ibendlin

     

    Thank you for your response. I'm expecting the result as below.

    Appreciate your help on this.

     

     

    Thanks

    Mahad

     

    • lbendlin's avatar
      lbendlin
      Super User
      4 years ago

      Please provide usable sanitized sample data that fully covers your issue.

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

         

        Dear Ibendlin

         

        Below are the "sales table" and "store master table"

        here the Qty Measure = sum('Sales Table'[Qty])
         
        I have similar scenario in current report. Please help me to achieve the cumulative % based on the above table data. 
         
        Thanks 
        Mahad