Ranking time (mm:ss) in ascending order

[Weatherreport]

Hello,

How can I rank the measure below in ascending order:

Time ranking = RANKX(ALL('Database'[Restaurant]),SUMX(RELATEDTABLE(Times), [KDS Kitchen Time]))

I tried this below but doesn't work:

Time ranking = RANKX(ALL('Database'[Restaurant]),SUMX(RELATEDTABLE(Times), [KDS Kitchen Time])),,ASC)

Thanks

[Weatherreport]

Thanks for your reply Fowmy.

I have now realised that it was working, the database table was not correct

[Fowmy · Accepted solution]

@Weatherreport 

If the following does not work, please share sample data and the expected result to understand the question.

Time ranking = 
RANKX(
    ALL('Database'[Restaurant]),
    calculate(
        SUMX(
            RELATEDTABLE(Times),
            [KDS Kitchen Time]
        )
    ),,ASC
)