Hemanth on 04 Dec 2016 07:40:58
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..
- Comments (1)
RE: Rankx in Direct Query Mode
'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