Forum Discussion
Using rankx and calculate
Hi everyone, So I used rankx in order to rank sales by client. My client asked me to show TOP 30 clients by sales, I did that filtering the object to show those 30. But my client also wants me to...
Hi, thank you for answering. Power BI allowed me to calculate the measure but it showed the total amount of sales.
Facturación = sum('BBDD UTMS'[Total Neto Faena USD]) ; total amount= $ 25.335.100
Ranking = RANKX(ALL('BBDD UTMS'[Cliente Madre]);CALCULATE(sum('BBDD UTMS'[Total Neto Faena USD])))
TOP 30 = SWITCH(TRUE();[Ranking]<=30;[Facturación]); total amount= $25.335.100 and it should be $21.386.471
What should I do?
Thank you :)
I'm not totally sure, It seems like it's just not pulling out the ranked as it's supposed to. I would try using ALLSELECTED instead of ALL in your ranking measure.
Changing to allselected didn't work :( Thank you for answering, though :)
I'm looking at this again, I think the rank formula is not quite right.
Try replacing the Calculate portion with your measure for the sum of sales.
I hope that works for you.