cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
obriaincian
Helper IV
Helper IV

Drill through for calculated tables

Hi All,

 

I have what seems is a simple request but I cannot find anything online.

 

I have a calculated table 

 

</

MakeTable =

SUMMARIZECOLUMNS(Data[Company],
// Required Through Calc
"Required Through",CALCULATE(COUNT(Data[Product ID]),DATESBETWEEN(SKU_Data[MakeReadyTF_SLPlanning],DATE(2019,1,1),Today())),

// Completed Through Calc
"Completed Through",CALCULATE(COUNT(Data[Product ID]),filter(Data,Data[CompletionPercent]=1) ,DATESBETWEEN(Data[Planning],DATE(2019,1,1),  Today())),

// Deliver Ready % Complete Calc
"Percentage Complete",[Make Ready Completed Through]/[Make Ready Required through],

 
"Completed due after previous month until today",CALCULATE(COUNT(Data[SKU]),filter(Data,Data[CompletionPercent]=1) ,DATESBETWEEN(Data[Planning],DATE(YEAR(today()), month(today()), 1),  Today()))

)
>
 
 
The column in this table are then added to a visual table. What I want to do is to be able to drill through on the visual table to another visual table that will contain the data in the data table.
 
 
The issue I have is that the drill through won't apprear on the visual table despite drill throguh fields being added
1 REPLY 1
amitchandak
Super User
Super User

@obriaincian , You need join it with common dimensions used on first page/visual on first page so that you can drill

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors