VAR Filter

[Anonymous]

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]))

Now i m stuck cause i dont know how to link SekundærNavn filter id to my formula. that divide function would take only "Touch up" category into consideration

[wdx223_Daniel · Accepted solution]

Touch up Yield =CALCULATE(DIVIDE(SUM(TJob[FirstPassQty]),SUM(TJob[Antal])),TJob[SekundærNavn] = "Touch up")

[Anonymous]

Both solution are working great!

Thank you both of you for quick answer

[Jihwan_Kim · Accepted solution]

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 · Accepted solution]

Touch up Yield =CALCULATE(DIVIDE(SUM(TJob[FirstPassQty]),SUM(TJob[Antal])),TJob[SekundærNavn] = "Touch up")