Forum Discussion
Drill Through Capability with multiple fields
I have a primary table that contains multiple fields, but in particular:
Call Id # (primary key), Previous Call Id (can be Null)
There are many related tables to the CallId and I have a drill-through page that presents the details related to the CallId. Main Report shows: Call Id, PreviousCall Id in one row of a table. I have a drill-through based on Call Id.
Users would like a drill through to Previous Call Id information. Previous Call Id would present all the same information from the same tables as the Call Id. How do I make this work without brining in a separate set of Call tables with the same info and joining on Previous Call Id instead of Call Id.
1 Reply
Hi lizrowden ,
Could you please post some simple sample data and your desired result to have a test if possible? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Regards,
Daniel He
