Ranking a field based on a measure

[bhmiller89]

I have a dataset where each record is a sale. One of the fields is "sales rep" and I have a measure written called "MTD Production$" 

I need to rank each Sales Rep by the value of the measure "MTD PRoduction$" So far I can't get anything to work. Any help is appreciated 

[ebeery · Accepted solution]

@bhmiller89 how about this:

Rank = 
RANKX(
    ALL('Table'[Sales rep]),
    [MTD Production $]
)