Using Running Total to find Associated Week numbers

[Tsepo]

Hi All,

I used a Quick measure to find running Sales total for the below table.

I would like to find Weeks when running Sales total was 25%, 50% and 75% of the Total Sales (5 835). I don't wish to manually add a calculated column to the above table.
Is there a solution besides adding a calculated column to my problem?

Thanks

[amitchandak]

@Tsepo , Are you looking for somthing like percentile ?

https://blog.enterprisedna.co/implementing-80-20-logic-in-your-power-bi-analysis/
https://forum.enterprisedna.co/t/testing-the-pareto-principle-80-20-rule-in-power-bi-w-dax/459

[Tsepo]

@amitchandak , Yes precisely.