Forum Discussion
Top 50 Ranking
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...
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.
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.