topic Re: VAR Filter in DAX Commands and Tips

VAR Filter

Anonymous — Wed, 24 Aug 2022 08:17:22 GMT

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

Re: VAR Filter

wdx223_Daniel — Wed, 24 Aug 2022 08:26:46 GMT

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

Re: VAR Filter

Jihwan_Kim — Wed, 24 Aug 2022 08:27:24 GMT

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

Re: VAR Filter

Anonymous — Wed, 24 Aug 2022 08:42:03 GMT

Both solution are working great!

Thank you both of you for quick answer