Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago

Unresolved problem with RANKX in DAX, repeated values with no result required

Good people! I need a help with the following in DAX. I have the table presented below with the data of amounts of each credit and its corresponding data of Amounts and Dates of Settlement and Gran...
johnt75's avatar
johnt75
Super User
3 years ago

The new RANK function allows you to use multiple criteria for ranking, e.g.

Rank measure =
RANK (
    SKIP,
    ALLSELECTED ( 'Credits' ),
    ORDERBY ( [AmountsDiv1000], DESC, 'Credits'[Fecha Liquidation], DESC )
)