Hi there.
I've got some curious puzzle to solve (might not be possible at all).
Here's the setup:
I have a page in a report that features a table. A simple table with, say, Device and and a [Total Runtime] measure; just 2 columns. I rank the devices by their runtimes (3rd column). I also have a slicer on the page with the devices' names only and I select some of them, so that the table shows only those selected in the slicer and the measure adjusts the ranks to what's seen in the table (meaning there's ALLSELECTED at work behind the scenes in the ranking measure).
Now, I'd like to have a drill-through page for the devices so that the rank from the parent page - meaning the rank calculated within the selected devices (not among all the devices in the system) - can be calculated, or somehow passed from the parent page, also in the drill-through page. Bear in mind that when you select just one device, it's this device that is passed to the drill-through page as the filter. Because of this, the ranking measure sees only this one device and the relative rank can't be calculated since on this page ALLSELECTED( Devices[Device] ) returns just this one device. From DAX I have no access to the set of devices selected on the parent page.
Any idea if this is at all doable? Is it at all possible to determine in the drill-through page which elements exist in the parent table from which we come and use this knowledge to create the relative rank? Or maybe there's a different way? Please note that it's easy to calculate the absolute rank among all the devices. One just uses the ALL function. But that's not what I want. I want the RELATIVE rank among the devices that have been selected in the parent page.
Thanks!
