topic Re: measure with multiple if statements in DAX Commands and Tips

measure with multiple if statements

fisqkuz1 — Tue, 12 Apr 2022 16:11:20 GMT

hi all

coming from a python background, i am trying to get the hang of dax.

however I am having trouble with the following attempt:

Revenue or Cost =

IF(table[col] = "short" & table[col2] > 0, 2, 1

ELIF(table[col] = "long" & table[col2] > 0, 1, 2

ELSE, 1, 2)

i can't figure out how to get this in a simple measure rather than a new column

Re: measure with multiple if statements

tamerj1 — Tue, 12 Apr 2022 16:19:38 GMT

Hi fisqkuz1
I don't fully understand your If - Else statement but you may try the following

Revenue or Cost = SUMX ( table, IF ( table[col] = "short" & table[col2] > 0, 2, IF ( table[col] = "long" & table[col2] > 0, 1, 2 ) ) )

Re: measure with multiple if statements

fisqkuz1 — Tue, 12 Apr 2022 16:23:18 GMT

hi, thanks for your answer!

i want to simply get a 1 or 2 as output such as booleans

where 1 = revenue and 2 = cost

Re: measure with multiple if statements

tamerj1 — Tue, 12 Apr 2022 16:26:30 GMT

The you use the sane logic. Only last oart shall not be required

Revenue or Cost = SUMX ( table, IF ( table[col] = "short" & table[col2] > 0, table[Revenue], IF ( table[col] = "long" & table[col2] > 0, table[Cost] ) ) )

Re: measure with multiple if statements

v-easonf-msft — Tue, 19 Apr 2022 07:49:14 GMT

Hi, fisqkuz1

Try measure formula like the following:

Measure = var _col=MAX('Table'[col]) var _col2=MAX('Table'[col2]) return SWITCH(TRUE(), _col="short"&&_col2>0,2, _col="short"&&_col2<>0,1, _col="long"&&_col2>0,1, _col="long"&&_col2<>0,2, 2 )

If it doesn't work, pelase share your sample data and expected result in excel.

Best Regards,
Community Support Team _ Eason