Sum measure row by by row

[Anonymous]

Hello everybody,

I have a measure named Net_Satis. I want to add another measer based on the conditions of Net_Satis.

If Summing Net_Satis from beginning  row  by row equals not total of Net_Satis * 0.70 then A

When take where left and sum again if sums equals to total of Net_Satis * 0.25 then B

When take where left and sum again if sums equals to total of Net_Satis * 0.05 then C.

I put some result to show you some details (but I got a wrong result).

I hope I clarified my question enough.

Thank you all

[v-xiaotang]

Hi @Anonymous 

I just want to confirm if you resolved this issue? If yes, you can accept the answer helpful as the solution or share you method and accept it as solution, thanks for your contribution to improve Power BI.

If you need more help, please let me know.

Best Regards,

Community Support Team _Tang

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

[davehus]

Hi @Anonymous , There are a couple of approaches to this. The link below gives you an outline of the methods. Measure or Column based.

https://www.daxpatterns.com/abc-classification/

K regards,

Dave

[amitchandak · Accepted solution]

@Anonymous , Are you trying ABC classification?

refer if these can help

ABC analysis
https://www.daxpatterns.com/abc-classification/
https://community.powerbi.com/t5/Desktop/ABC-Analysis/td-p/309108
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-ABC-Classification/td-p/479146