Rank by Total

[CBurton87]

Hi,

I'm trying to find a way to create a measure that ignores months when ranking.

the reason for this is im trying to create a graph that shows the monthly trend of an End Market based on its overall rank.

so in the graph, if i filter on Rank 2, we would want to see the monthly performance of End Market B.

Currently what we would get is End Market B for Jul-19 but End Market A for Aug-19.

Current DAX: 

End Market Rank = RANKX(ALL('Sales Table'[End Market]),[Actuals $])

is there a way, using the example above to have Rank 2 appear in all months for End Market B? instead of calculating each month individually?

thanks in advance.

Craig

[sturlaws · Accepted solution]

Hi @CBurton87 

can you try something like this:

End Market Rank = RANKX(ALL('Sales Table'[End Market]),calculate([Actuals $],all([Months])))

Cheers,
Sturla