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 need to identify the most sold products which represent 80% of my sales. For instance:
PRODUCT SALES CUMULATIVE SALES
A 50 50
B 20 70
C 10 80
D 8 88
E 7 95
F 5 100
Therefore, products A, B and C represents 80% of my sales.
I am able to get cumulative sales with a date dimension, but for this exercise, date is not taken into account.
Regards.
Solved! Go to Solution.
Cumulative is based on the sort order , You can sort on sales
Cumm1 = CALCULATE(sum('product'[SALES]),FILTER(all('product'),'product'[SALES]>=MAX('product'[SALES])))
Better you create a dense rank and use that. New column
rank = ranks(all(Product),Product[sales],,asc,dense)
Use rank in last formula
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 |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |