Forum Discussion

DataSkills's avatar
DataSkills
Icon for Resolver I rankResolver I
2 years ago
Solved

Rankx should be easy! Why doesn't this work?

I am attempting to create the simplest of Rank measures! I have a single table (SalesData) of data, with a column called "Cost of Sales".  I want to create a basic rankx function which ranks a dim...
DAX
RANKX
  • ValtteriN's avatar
    ValtteriN
    2 years ago

    Hello, 

    You were on the right track by using ALL. The only issue now is that since you remove all filters the values are same for all rows so every row returns one. By adding a column reference  the calculation should work. E.g. all(SalesTable[Region])

    I recommend checking this article by SQLBI: Introducing RANKX in DAX - SQLBI

    I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

    My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

DataSkills's avatar
DataSkills
Icon for Resolver I rankResolver I
2 years ago

Whilst ValtteriN solution works, I am still a bit confused about this. Reviewing several articles about this function, the implication is you can simply use a format like RANKX(SalesTable, [COS Measure]). 

 

Eg https://databear.com/how-to-use-the-dax-rankx-function-in-power-bi/

 

In this article it states: 

RANKX(
‘Sales Table’,
‘Sales Table'[Total Sales]
)
 
But this doesn't work in my case.