Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Cumulative Sum and Cumulative Sum Percentage

Hi, I have a dataset which contains a case number, opended date, response target, response deviation in minutes. I added a custom column called First Response Calc for calculating the response targe...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi  Anonymous ,

    Modify the measure to the following form:

    1. Create measure.

    Measure =
var _1=COUNTX(FILTER(ALL('Sheet1'),'Sheet1'[_Histo FRT]<=MAX('Sheet1'[_Histo FRT])),[CaseNumber])
var _2=COUNTX(ALL('Sheet1'),'Sheet1'[_Opened Cases])
return
DIVIDE(_1,_2)

    2. Result:

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

goncalogeraldes's avatar
goncalogeraldes
Icon for Super User rankSuper User
5 years ago

Hello there Anonymous ! Just as a suggestion, to simplify your coding steps and the readability the formulas you develop try using the SWITCH function instead of the multiple IFs() in the  "_Histo FRT". It may not only help you create simpler measures but also evaluate possible errors.

 

Regarding your question, you can check similar these threads with solutions provided for similar questions to yours:

 

https://community.powerbi.com/t5/Desktop/cumulative-running-total-percentage/m-p/384190

https://community.powerbi.com/t5/Desktop/Calculate-cumulative-percentage-from-a-calculated-column/m-p/428926

https://community.powerbi.com/t5/Desktop/cumulative-percentages/m-p/571128

 

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!

You can also check out my LinkedIn!

Best regards,
Gonçalo Geraldes

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Goncalo,

 

Thanks for your reply. I looked into those three forum questions before I sent the question out. They don't seem to work for what I want to do. I don't have a product with a sales dollar amount.

I have a number of cases within a time range. I am looking to calculate the cumulative percentage of cases as it refers to a particular time instance (0-15 minutes, 30-60 minutes, etc..)