Cumulative percentage of purchases to suppliers

[Anonymous]

Hello,

I want to find the cumulative percentage of the purchases made to suppliers.

I have a measure that calculates the total purchases by supplier :

Product Purchases = SUMX(VALUES('All'[Nom fournisseur]),CALCULATE(SUM('All'[Valeur CHF])))

And I tried to calculate the cumulative percentage :

Cumulative Percentage =

var sales=CALCULATE(SUM('All'[Valeur CHF]),FILTER(ALLSELECTED('All'[Nom fournisseur]),ISONORAFTER('All'[Nom fournisseur],MAX('All'[Nom fournisseur]),DESC)))

var totalsales=CALCULATE(SUM('All'[Valeur CHF]),ALLSELECTED('All'))

return DIVIDE(sales,totalsales)

However, with this way of doing things, the cumulation is done by the alphabetic supplier name and not by the total amount of purchases.

Can you please help me to make the cumulation by the total amount of purchases by supplier ?

Thank you in advance.

AlBers