To *Bleep* with RANKX!
Perhaps no other function in the DAX language has caused more grief and strife than RANKX (other than perhaps the entire suite of time "intelligence" functions). Not a day goes by in the forums that ...
Greg_Deckler , I'm having trouble with getting this to work (specifically the last formula).
Instead of the rank, I'm simply getting a count of all the distinct groups that have sales for a particular product.
Have logged a post here: https://community.powerbi.com/t5/Desktop/Summarized-Ranking-with-RLS/td-p/3204959
Would really appreciate some help.
Many thanks