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