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 advise how to attached the .pbix file when raising a help request on this forum.

 

Thanks in advance

Mahad

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.

10 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    4 years ago

    Hi,

    Share the link from where i can download your PBI file.  You may upload the file to Google Drive/One Drive or any such similar service and share the download link.

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