Forum Discussion
Measure using IF column and AND measure =
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?
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 __ResultWhen 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.
2 Replies
- Greg_Deckler
Community Champion
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 __ResultWhen 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.
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
