Forum Discussion

gmasta1129's avatar
gmasta1129
Icon for Resolver I rankResolver I
1 year ago
Solved

Formula for Rank (based on a measure)

Hello, I created a table in Power BI that contains the following columns + one measure   1. Run Date --> Column 2. Facility Code --> Column 3. Facility Name --> Column 4. Overall Score --> Meas...
Need Help
  • SundarRaj's avatar
    SundarRaj
    1 year ago

    Hi gmasta1129 ,
    Please try if this gives you the desired result that you are looking for. Thanks

    RankX =
    RANKX(
    ALL('Table'[Facility Code] , 'Table'[Facility Name] , 'Table'[Run Date])
    [Overall Score],
    ,
    DESC,
    DENSE
    )

SundarRaj's avatar
SundarRaj
Icon for Super User rankSuper User
1 year ago

Hi gmasta1129 ,
Please try if this gives you the desired result that you are looking for. Thanks

RankX =
RANKX(
ALL('Table'[Facility Code] , 'Table'[Facility Name] , 'Table'[Run Date])
[Overall Score],
,
DESC,
DENSE
)

  • gmasta1129's avatar
    gmasta1129
    Icon for Resolver I rankResolver I
    1 year ago

    The formula worked.  

    Thank you for your help! 🙂