Drill-Through Report with Different Tables

bellabelbel Hey,

• Use a shared Work Item dimension for drill‑through (not fields from separate fact tables). Create a DimWorkItem with Id, ParentId, WorkItemType, Title, State, etc. Relate Fact Work Items[WorkItemId] → DimWorkItem[Id] and Gather Documentation[WorkItemId] → DimWorkItem[Id]. Set the drill‑through field to DimWorkItem[Id] (or a surrogate key from this dimension). This ensures the drill context flows to both pages/tables.

• Drive hierarchy on the drill‑through page from that dimension. Add hierarchy logic in DimWorkItem (Path = PATH(Id, ParentId); EpicId = VALUE(PATHITEM(Path, PATHLENGTH(Path)))). Build your table visual from DimWorkItem and filter rows where [EpicId] equals the drilled value (e.g., a simple measure: ShowUnderSelectedEpic = IF(MIN(DimWorkItem[EpicId]) = SELECTEDVALUE(DimWorkItem[Id]), 1, 0) and set visual filter = 1). This will list Features, User Stories, and Tasks under the selected Epic.
  
  

  Thanks

  Haish K 

  If I resolve your issue. Kindly give kudos to this post and accept it as a solution so other can refer this.