Subtract a constant from a measure
I'm trying to create a measure on DAX that have to subtract 2 measures from a constant (that is 14). The problem is that when I calculate it it duplicates the results row. Here's the formula: Missed flows = (14 - CALCULATE( DMSFact'[# Not Available] ) )-'DMSFact'[Dealer_TOT_Y] where # Not Available and Dealer_TOT_Y are two count measure: Dealer_TOT_Y = CALCULATE(COUNT('DMSFact'[Dealer Int]) ,'DMSFact'[Dealer Int]="Y" ,GROUPBY('DMSFact','DMSFact'[Dealer Code])) # Not Available = CALCULATE(COUNT('DMSFact'[Flag NotAvailable]) ,'DMSFact'[Flag NotAvailable]="Y" ) The result I want to display is the Missed flows for each dealer, in such a form: Insted I get this:
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" ) )
