RANKX with ASC Resuts

sezerunar Hi!
Try with this adjusted measure:

VAR SelectedSpecialId = SELECTEDVALUE(bio_data[unique])
VAR SelectedLeague = SELECTEDVALUE(bio_data[league])

VAR PositionFilter = SELECTEDVALUE(YES_NO_TABLE[Filter]) = "Yes"
VAR DefoultPosition = SELECTEDVALUE(bio_data[template_position])
VAR SelectedPositions = ALLSELECTED(POSITION_ORDER[template_position])

VAR CurrentDefLabel = SELECTEDVALUE(def_data[def_label])

VAR FictionalTable =
CALCULATETABLE(
VALUES(bio_data[unique]),
ALL(bio_data),
bio_data[league] = SelectedLeague &&
(IF(PositionFilter, bio_data[template_position] = DefoultPosition, bio_data[template_position] IN SelectedPositions) || bio_data[unique] = SelectedSpecialId)
)

VAR UniqueObservations = FictionalTable

VAR TotalPlayers = COUNTROWS(FictionalTable)

RETURN
TotalPlayers + 1 - RANKX (
FILTER(
ALLEXCEPT(def_data, def_data[def_label]),
(
def_data[unique] IN UniqueObservations
)
),
CALCULATE ( SUM(def_data[def_value]),
(
def_data[unique] IN UniqueObservations
)
),
,
DESC
)

BBF

Hello sezerunar,

Here's a couple of things to consider and troubleshooting steps you can take:

• Given that def_data is in long format, ensure that there aren't any duplicate entries for a given unique and def_label combination.
• You are using ALLEXCEPT(def_data, def_data[def_label]). This means that you are ranking over all values of def_data except for the ones associated with the currently selected def_label. If there are many other columns in def_data not related to your desired ranking, this could result in a huge ranking number.
• If you have DAX Studio, you can use the EVALUATE function to look at the intermediate table results (This can help you inspect the FictionalTable and the filtered table you pass into RANKX to ensure they're what you expect)

Should you require any further assistance, please do not hesitate to reach out to me.