Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Hi,
Share the link from where i can download your PBI file.
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 formule is not working. Sales amount is sum of sales. (measure)
Oh Oh!!! I thought it was your table structure. I didn't know the "Sales" was a measure.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |