cumulative count based on rank sales

[Anonymous]

Hi, 

I have a table of suppliers, total sales pr supplier, share of total sales. 
I would like to have a cumulative count of suppliers, see column cumulativ suppliers 

Example:

suppliers    sales    share   number of supplier    cumulative suppliers

A                 1000     86%           1                       1

B                  100       8,6%           1                      2
C                   50        ..                 1                      3
D                   10       ....                1                       4

[Ashish_Mathur]

Hi,

Share the link from where i can download your PBI file.

[Anonymous]

CumulativeSuppliers = RANKX(Suppliers,Suppliers[Suppliers]&Suppliers[Sales],,ASC)

Instead of this, you could have used the following...

CS = RANKX(Suppliers,Suppliers[Sales])

But if two suppliers have the same sales figures, you will get the same number for both. To avoid this, I have modified the same as shown in the first formula.

[Anonymous]

@Anonymous formule is not working. Sales amount is sum of sales. (measure)

[Anonymous]

Oh Oh!!! I thought it was your table structure. I didn't know the "Sales" was a measure.