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.

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
    • 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.