Solved: Direct Query and RANKX

tsmehta · ‎01-06-2022

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 !

v-shex-msft · ‎01-09-2022

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

v-shex-msft · ‎01-09-2022

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Direct Query and RANKX

Helpful resources

Power BI Monthly Update - April 2024