Need to rank customers by revenue in direct query mode for dynamic selections usong slicers

[Anonymous]

Hi, I need to show top 5 customers by revenue based on selected country/ countries. But then, in direct query there is no support for rankx. Selections are dynamic and hence, it is not be possible to create a ranking as part of view.any help on this would be appreciated.

[Eric_Zhang · Accepted solution]

@Anonymous

Try a workaround with a measure to show TOP N in your  data. Check more details in the attached pbix.

Measure = IF(CONTAINS(TOPN(2,ALLSELECTED('Table'),'Table'[val],ASC),'Table'[id],MAX('Table'[id])),MAX('Table'[id]),BLANK())

[pandakillsalot]

Why both topn and rankx are not supported in my version? I got the same error.