Rankx in Direct Query Mode

[hemanth]

Rankx function needs to be supported in Direct Query Mode. If I am not using Analysis Services I should be able to still create a measure of Rank and also create things like Top 10 etc..

[dylan_morgan]

'You can use countx over a filtered table to get this result. Essentially you want to iterate over a table. The basic implementation is as follows. You would want to decide how to handle ties and make adjustments, but for a simple implementation this will work. = VAR thisSales = EmployeeSales[Sales] RETURN COUNTX( FILTER( ALL('EmployeeSales'), 'EmployeeSales'[Sales] > thisSales ), [Sales] ) + 1