topic Re: Question about ranking Rankx in monthly result in DAX Commands and Tips

Question about ranking Rankx in monthly result

Anonymous — Mon, 15 Aug 2022 22:02:57 GMT

I want to show everyone's monthly ranking per Gross Margin $. However, some people ranking is incorrect. For example as below, this person Monthly ranking should be 4,6,4,6,3,1,1. In the chart, April and July ranking shows incorrectly.

My Dax as below, please advice.

Monthly Ranking =

IF(

ISFILTERED(Employee[Person Name by Last]),

RANKX(

CALCULATETABLE(

Employee,

all(Employee[Person Name by Last]),

Employee[Pres. Club Elig]=TRUE()

[YTD GM]

BLANK()

)

Thanks!

Re: Question about ranking Rankx in monthly result

yaowen — Tue, 16 Aug 2022 01:04:16 GMT

It is suggested to cut the table data to make it clearer. Try this code：

Monthly Ranking =
IF (
    ISFILTERED ( Employee[Person Name by Last] ),
    RANKX ( ALLEXCEPT ( Employee, Employee[Person Name by Last] ), [YTD GM] ),
    BLANK ()
)

Re: Question about ranking Rankx in monthly result

Anonymous — Wed, 17 Aug 2022 16:06:24 GMT

Thanks for the suggestion! I tried the DAX, it is not working properly. It shows as following.

Re: Question about ranking Rankx in monthly result

Anonymous — Thu, 18 Aug 2022 05:53:20 GMT

Hi Anonymous ,

If it is convenient, can you send me a sample data or a PBIX file without private data for my testing?

Best regards,

Community Support Team Selina zhu

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