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

 

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
Icon for Super User rankSuper 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.