Forum Discussion

gmasta1129's avatar
gmasta1129
Resolver 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
    )

gmasta1129's avatar
gmasta1129
Resolver I
1 year ago

Hello SamsonTruong ,

 

Thanks for the quick response. I entered the formula and pulled the measure into my table.  I see a value of 1 for each row.  

 

  • SamsonTruong's avatar
    SamsonTruong
    Super User
    1 year ago

    Hi gmasta1129 , by any chance can you attach the DAX for the Overall Score measure?

    Additionally, can you try the following DAX measure:

    Rank by Score = 
RANKX(
    ALLSELECTED('Table'[Facility Code]),
    CALCULATE([Overall Score]),
    ,
    DESC,
    DENSE
)