Forum Discussion
Solution SageData order same as the Original Query
I found a solution.
What I did was, I have created a custom column and Concatenated the required columns then put that custom column and sorted.
Solution SageThanks Tom,
yes, i am referring to "order of the rows".
I guess, RankX won't work in Direct Query Mode.
Super UserHey,
according to this list:
RANKX is one of the not optimized functions (for direct query), I just tested it and it works. I have no idea how this will behave from a performance perspective.
Regards,
Tom
- rocky09
Thank you again,
but, not working. I am getting the error that RANKX cannot be used on Direct Query.
- rocky09
I found a solution.
What I did was, I have created a custom column and Concatenated the required columns then put that custom column and sorted.
- TomMartens
Hey, this is cool.
Maybe this post is of interest:
prior to the July release there has been an option to allow unrestricted measures (meaning allow more DAX functions in measures) using direct query.
Maybe you want to check if you have the "preview" feature "Composite Models" enabled.
Options -> Preview Features.
I tested RANKX in direct query mode against a SQL Server table without an error message.
Regards,
Tom