Writing a RANK measure (and living to tell the tale)

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
 

Before I get started, do you have any idea how hard it is to find cartoon images from the pre-Internet era?  I just lost ninety minutes, first looking for the Far Side cartoon of “Custer’s Last Group Photo” (where everyone is holding up the “we’re number 1!” finger – get it?) and then struggling to find a version of the Beavis and Butthead image above at a better size.  No dice.  OK, enough of that…

DAX v1 has no RANK() function

That’s right.  If you want to write a pivot measure that tells you where a particular store, or product, or customer ranks according to another measure, and according to current filter context, well, a RANK() function would be nice.  But there wasn’t time to implement it in PowerPivot v1.

Read more...

Rank continued – dealing with unknown members...

Rank measure finished...

 

 

Tags: dax, excel

 

2007-2015 VidasSoft Systems Inc.