Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Managers by Sales within each Month

Attached is a screenshot of my model with all tables & columns.

My goal is to create either a column or measure to rank Managers by Sales within each Month.

Table "Manager & Month" was created by me & has a row for each Manager with each Month.

I have tried many things, starting with: SalesRank = RANKX(ALL(Manager & Month), SUM(Sales))

I have tried inserting ALLEXCEPT & ALLSELECTED into the calculation as well with no success.

 

Thanks in advance!

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago
    I pulled Manager into Sales table, created M&Mid columns in both "Sales" & "Manager & Months" tables, then created relationship with that field. This measure in the Manager & Months table was the solution: ***RANK WORKS*** = RANKX(ALL('Manager & Month'[Manager]),[SumSales],,,Dense)

3 Replies