Forum Discussion
RANKX on measure
Hi All, I'm relatively new to PowerBI and moreso DAX. I am having an issue trying to do a RANKX on a "Total_Cost" measure within one of my reports. So what I have right now is a list of items per...
Almost Sean, but thank you!
I actually got it exactly where I want it to be, except now it's just missing Rank 1 in the live data, where in my data from Excel (same exact rows, just pasted from SQL). Any idea why that would happen?
v-qiuyu-msft
Community Support
Community SupportHi Flynnk31,
As you rank values in No_ groups, please use the matrix instead of table visual to display rank values. You can place No_column in Row group of matrix. And have you tried the Rank Measure suggested by Sean?
Rank Measure = RANKX( ALLEXCEPT('Table', 'Table'[No_]), [Total Cost Measure] ,, DESC)
Best Regards,
Qiuyun Yu