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.
Good morning,
I have a problem with a calculation. I want to do a PARETO Chart. I used the tutorial at this address : https://powerbi.tips/2016/10/pareto-charting/
But when I do it, it doesn't work beacause some of my Sum Sales are equal and the measures don't work. I let you see on this picture :
As you can see, the last calculations are wrong because the ranking is the same for the two last lines. I give you the formula I used :
Ranking = RANKX( 'Summary', 'Summary'[Sum Sales])
Cumulative Total = CALCULATE( SUM( Summary[Sum Sales] ), FILTER( ALLSELECTED( Summary ), Summary[Ranking] <= MAX( Summary[Ranking] ) ))
Total Sales = CALCULATE( SUM( Summary[Sum Sales] ) , ALLSELECTED( Summary ) )
Cumulative Percent = [Cumulative Total] / [Total Sales]
Do you have any idea do correct my calculations please ?
Thank you for your help.
Solved! Go to Solution.
Create an additional column that is different from the similar Sales Column
SupportCol = Data[Sales]+(RANDBETWEEN(1,100)/10000000)
This will add decimal value to the similar numbers hence making it non similar.
Then do the ranking based on this SupportCol
RANKX(TableName,[SupportCol],,DESC)
Calculations seems fine just do one thing,
In the table properties, choose Don't Summarize for Weeks & Ranking.
It's grouping them hence similar figures.
All the fields are already not summarize and that gives me this result.
The problem is the ranking, it is giving same Ranks for two similar figures.
I have tried to find it out but couldn't succed in getting a good solution for Ranking of same figures.
Create an additional column that is different from the similar Sales Column
SupportCol = Data[Sales]+(RANDBETWEEN(1,100)/10000000)
This will add decimal value to the similar numbers hence making it non similar.
Then do the ranking based on this SupportCol
RANKX(TableName,[SupportCol],,DESC)
It works! Thank you SO MUCH!!
Thank you it looks working. 🙂
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |