Report Portal

DAX: Returning the Nth Selected Value in a Slicer

A client came to me with a challenge this week that, although simple in concept, posed an interesting challenge that I hadn't solved before using a tabular model and DAX. She had cost information for several hospitals in a PowerPivot model. Using an Excel pivot table published to a SharePoint site, users were to select any combination of hospitals using a slicer and compare relative costs for these facilities and other measure values. After working on the problem and have two working solutions. I don't think one is necessarily better or worse than the other but each have advantages over the other. Thanks to Rob Collie and Marco Russo for their contributions as we've discussed potential solutions.


Tags: design, dax, tabular


2007-2015 VidasSoft Systems Inc.