Direct Query and RANKX

[tsmehta]

After trying for a number of times finally was able to use RANKX for direct query data. Do let me know if you are stuck up with this. Happy to help ! 

[Anonymous · Accepted solution]

Hi @tsmehta,

Current power bi has limited most of the Dax function used to create calculated columns or tables if you are working on direct query mode. I'd like to suggest you create a measure expression instead.
Regards,

Xiaoxin Sheng