Forum Discussion

daniel_ricardo's avatar
daniel_ricardo
Frequent Visitor
3 years ago

ranking

I need to rank sellers based on a field that is not being filtered in the visual, just by the team that the seller belongs. It's a report made to the seller, so he must see his position among sellers...
FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

or you add a calculated column like:

RankingColumn = 
RANKX(
    FILTER(
        TableName,
        TableName[Team] = EARLIER(TableName[Team])
    ),
    TableName[Sales],
    ,ASC
)

 

it worked like: