Forum Discussion
Drillthrough with measures
Anonymous - One possibility:
1. Create a disconnected parameter table that contains your bucket categories.
2. Create a Measure which checks SELECTEDVALUE of the parameter table in a SWITCH statement. So, the value that the measure returns will be dependent on which bucket you're checking.
3. Create your visual with the new parameter table and new measure.
Cheers!
Nathan
Anonymousthat's basically exactly what I've done, but it severely disconnects the drillthrough unfortunately such that it no longer works correctly.
Anonymous -
Ah, sorry about that - I started thinking about how it should work (without the drillthrough piece).
I guess the only way it would work to drillthrough on a disconnected table is to have all of the other measures on the drillthrough page also be affected by that table. Rows that aren't associated with the selected bucket would have BLANK values returned from the measures and therefore be excluded.
Hope this helps,
Nathan