Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

VAR Filter

Hello,   I ve written dax   Touch up Yield = VAR     Touchup = FILTER(TJob, TJob[SekundærNavn] = "Touch up" ) Return     DIVIDE(SUMX(TJob, TJob[FirstPassQty]), SUMX(TJob, TJob[Antal]))   ...
  • wdx223_Daniel's avatar
    wdx223_Daniel
    4 years ago
    Touch up Yield =CALCULATE(DIVIDE(SUM(TJob[FirstPassQty]),SUM(TJob[Antal])),TJob[SekundærNavn] = "Touch up")
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    Hi,

    I am not sure if I understood your question correctly, but please try the below whether it suits your requirement.

     

    Touch up Yield =
VAR Touchup =
    FILTER ( TJob, TJob[SekundærNavn] = "Touch up" )
RETURN
    DIVIDE ( SUMX ( Touchup, TJob[FirstPassQty] ), SUMX ( Touchup, TJob[Antal] ) )
wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
4 years ago
Touch up Yield =CALCULATE(DIVIDE(SUM(TJob[FirstPassQty]),SUM(TJob[Antal])),TJob[SekundærNavn] = "Touch up")