Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Rankx with filter

Hi Geniuses,  All helps are appreciated, currently I am using below DAX formula to rank my salesmen but I want to create a DAX formula where I can rank them category [Channel] wise and I want to u...
Rankx with filter
selimovd's avatar
selimovd
Icon for Most Valuable Professional rankMost Valuable Professional
5 years ago

Hey Anonymous ,

 

I didn't fully understand what the result should the look like.

But I think Greg_Deckler had the right approach. Try the following measure:

SWA Ranking ALL Channel =
RANKX(
    ALLSELECTED( 'outlet-report' ),
    [Avg Ach of Core & Premium],
    ,
    DESC
)

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis