Codice: Seleziona tutto
Issue050922 = SUMMARIZE(T_KPI_Plant_DetailAllData, T_KPI_Plant_DetailAllData[DataOraInserimento], T_KPI_Plant_DetailAllData[QDALevel], T_KPI_Plant_DetailAllData[Anno], T_KPI_Plant_DetailAllData[Mese], T_KPI_Plant_DetailAllData[InspectionPlan], T_KPI_Plant_DetailAllData[Characteristic], T_KPI_Plant_DetailAllData[OrderNum],"Issue%",(SUM(T_KPI_Plant_DetailAllData[BatchKO]))/DISTINCTCOUNT(T_KPI_Plant_DetailAllData[OrderNum]))
Codice: Seleziona tutto
Misura123 = DISTINCTCOUNT(T_KPI_Plant_DetailAllData[OrderNum])