cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Weatherreport
Frequent Visitor

Ranking time (mm:ss) in ascending order

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
1 ACCEPTED SOLUTION
Fowmy
Super User IV
Super User IV

@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
)



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Website   YouTube    LinkedIn   Join my Power BI User

View solution in original post

2 REPLIES 2
Weatherreport
Frequent Visitor

Thanks for your reply Fowmy.

 

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

Fowmy
Super User IV
Super User IV

@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
)



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Website   YouTube    LinkedIn   Join my Power BI User

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates