Top 50 Ranking

[Anonymous]

Hi i need to convert below query into Dax.
SELECT top 50
RANK()OVER (ORDER BY SUM(LINE_AMT_Paid) DESC) AS Ranking

I converted as below into DAX but its not given correct results, i want to display unique rank for Top 5o records.

Ranking = SUM('Fact Claim'[Paid Original Amount])

Ranking1 = RANKX(ALL('Fact Claim'),[Ranking],,DESC)

But it's not displaying data rank wise and showing as sum  need to display data like second screen shot.

[v-yuta-msft · Accepted solution]

@Anonymous ,

Please modify the measure like pattern below and check if this issue persists:

Ranking1 =
RANKX (
    ALL ( 'Fact Claim' ),
    CALCULATE ( SUM ( 'Fact Claim'[Paid Original Amount] ) ),
    ,
    DESC
)

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

RANKX can be a pain, can you provide sample data?

https://www.sqlbi.com/articles/use-of-rankx-in-power-bi-measures/

[Anonymous]

How to to convert below sql into DAX show TOP 50 records based Rank wise. Here all columns comes from different tables . Please SELECT top 50 RANK()OVER (ORDER BY SUM(LINE Amount) DESC) AS Ranking,

Fact Table,

Network Licence Number, ( Network Table)

Provider ID (provider Table)

Provider Name (Provider Table)

SUM(LINE Amount) as Paid,(Fact Table)

COUNT(Claim Number) as Services,(Fact  Table)

COUNT(DISTINCT(MEM_ID))as Patients-- Fact