Forum Discussion
Get Top N of a category by a value using DAX function RANKX() and a tie breaker.
I thought I was following the pattern provided in the post: Breaking Ties in Rankings with RANKX Using Multipl... - Microsoft Power BI Community when I wrote the DAX below. It doesn't error, and it...
Hi, Anonymous ;
Try it.
RankedByMoney(CareGapsToPotential) = RANKX ( ALL ( HN_CHIP ), RANKX ( ALL ( HN_CHIP ), 'HN_CHIP'[Money Left on the Table],, ASC ) * ( COUNTROWS ( 'HN_CHIP' ) + 1 ) + RANKX ( ALL ( HN_CHIP ), 'HN_CHIP'[Care Gaps to Potential],, DESC ) )The final output is shown below:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.I created a rank in MS SQL Server using ROW_NUMBER() OVER(PARTITION BY ... ORDER BY...)
Now I have this:
Could the manual filter over "Measure" be disables so we can be sure it is not interfereing with the DAX calculation. Care Gaps.... should be ascending within one value of Money....
Thank you,
Mo