Rank by created date and company name

[Anonymous]

I have table Company. I need to display the TOP 6 recently created. Exemple of data:

Expected results

What I tried :

Rank = 

VAR d = Companies[CreatedDate].[Date] 

RETURN

    CALCULATE (

        RANK.EQ ( d, Companies[CreatedDate], DESC)

    )

the calculated column returned wrong values:

I need to order by creatd date, and when it's the same date, I need to order by Company Name

How to correct it

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[Icey · Accepted solution]

Hi @Anonymous ,

You can also try this:

Measure =
RANKX (
    ALLSELECTED ( 'Table' ),
    RANKX (
        ALLSELECTED ( 'Table' ),
        CALCULATE ( MAX ( 'Table'[Created Date] ) ),
        ,
        DESC,
        DENSE
    ) * 100
        + RANKX (
            ALLSELECTED ( 'Table' ),
            CALCULATE ( MAX ( 'Table'[Company Name] ) ),
            ,
            DESC,
            DENSE
        ),
    ,
    ASC,
    DENSE
)

Best Regards,

Icey

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

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[Greg_Deckler]

@Anonymous Hmm. Well, you could try out the different options for RANKX instead of RANK.EQ. Provides some additional options around breaking ties and the like:

https://community.powerbi.com/t5/Quick-Measures-Gallery/To-Bleep-with-RANKX/m-p/1042520#M452

Also might try something like the Mythical DAX Index:

https://community.powerbi.com/t5/Quick-Measures-Gallery/The-Mythical-DAX-Index/m-p/1093214#M528