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...
Sean
Community Champion
Community Champion
I think its your Total Cost Measure causing the problems - change it to just this....
Total_Cost = SUM(DaysToConsumption[TotalCost])
Good Luck! :smileyhappy:
Thanks for the help!
So I changed the Total_Cost to:
Total_Cost = SUM(DaysToConsumption[TotalCost])
And Rank to:
Rank = RANKX(ALL(DaysToConsumption), [Total_Cost], , DESC)
but it is still giving the same results, not sure what else could be throwing this off.
