Forum Discussion
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...
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
)
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
)
The formula worked.
Thank you for your help! 🙂