Forum Discussion
Rank in direct query mode
Hi,
How would I go about ranking values in direct query mode. The DAX function RANK does not seem to work.
Any help appreciated
TIA
Chris
Looks like it is not supported . It should get added as a feature
6 Replies
Looks like it is not supported . It should get added as a feature
Did you work it out?
I faced this a couple of months ago
two ways to do this, you can create a Measure using rankx
this means that when you slice your data, your rankings get recalculated
another option is to do the rank within the SQL select query
this means your ranking remains the same regardless of how you slice your data
this will show you how to do it the SQL way: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=109028
Thank you so much for your reply. I tried the RANKX way but I got an error saying the RankX function is not supported under direct query model. How did you solve it? By rankx or SQL ?
go to file->options and settings -> options
under direct query, select "allow unrestricted measures"
