Forum Discussion

CBurton87's avatar
CBurton87
Frequent Visitor
6 years ago
Solved

Rank by Total

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's avatar
    sturlaws
    6 years ago

    Hi CBurton87 

     

    can you try something like this:

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



    Cheers,
    Sturla

1 Reply

  • sturlaws's avatar
    sturlaws
    Resident Rockstar
    6 years ago

    Hi CBurton87 

     

    can you try something like this:

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



    Cheers,
    Sturla