topic Measure using IF column and AND measure = in DAX Commands and Tips

Measure using IF column and AND measure =

jrdwthomas — Wed, 22 Mar 2023 12:15:23 GMT

Hello all,

New to the world of DAX after years of using Microstrategy and Qlik.

I'm struggling to get my head around a few calculations/statements. Would someone be able to assist with my current issue:

if("MARKET" = 'CN' and "Value" < 0.001, 0,
if("MARKET" = 'JP' and "Value" < 0.001,0,
"Tot_gross")) as "Gross"

Market, Value and Tot_gross are all in the same table. When i try to calculate a new measure using the IF statement it doesn't let me select the neccessry column (in this case 'Market')

What am i doing wrong?

Re: Measure using IF column and AND measure =

Greg_Deckler — Wed, 22 Mar 2023 12:19:43 GMT

jrdwthomas Try:

Measure = VAR __Market = MAX('Table'[Market]) VAR __Value = MAX('Table'[Value]) VAR __TotGross = MAX('Table'[Tot_gross]) VAR __Result = SWITCH(TRUE(), __Market = "CN" && [Value] < 0.001,0, __Market = "JP" && [Value] < 0.001,0, [Tot_gross] ) RETURN __Result

When you have a measure, you have to wrap column references in an aggregator. Check out my YouTube channel, DAX For Humans. It is specifically geared toward teaching people that are new to DAX the fundamentals.

DAX For Humans - YouTube

Re: Measure using IF column and AND measure =

jrdwthomas — Wed, 22 Mar 2023 12:57:25 GMT

Well that resultant syntax didn't look anything like what i expected. Seems i've got a lot of learning to do. The only thing i changed was the

MAX('Table'[Tot_gross]) to instead use SUM('Table'[Tot_gross])

That seems to now give me the output needed.

Thank you very much for your quick assistance. Much appreciated