DAX virtual summarized table
Hi All, Please, if any one can help it will be much appreciated. I have the following summarized table to calculate the over all yield, and i cannot see where my mistake is? I get the error at the bottom of the code: "The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value" here is the code for the measure: OverAllYield1 = SUMMARIZE ( 'ABU_Yield-Qty_Data1', 'ABU_Yield-Qty_Data1'[DIE_TYPE], 'ABU_Yield-Qty_Data1'[FT_PRODUCT], 'ABU_Yield-Qty_Data1'[Test Insertion], 'ABU_Yield-Qty_Data1'[Test Flow], 'ABU_Yield-Qty_Data1'[Insertion Temp], "FT Final Pass Over All Yield Avg1", CALCULATE ( AVERAGE ( 'ABU_Yield-Qty_Data1'[Yield (%)] ), 'ABU_Yield-Qty_Data1'[Test Flow]="FT", 'ABU_Yield-Qty_Data1'[Test Insertion]="Final Insertion" ) )
