Forum Discussion
Anonymous
5 years agoNot applicable
Switch doesn't support true/false
I'm getting error for the following dax measure.
Each variable returns a number and in switch case I want to compare ok number with not ok number.
If check1 is greater or equal than check2 , it'll return 1 otherwise 0.
Function switch does not support comparing values of type true/false with values of type text.
CheckLine status:=
Var check1=SUMX(SUMMARIZE('order','order'[orderid],"order ok",MAX('order'[Order check ok line1])),[order ok]
)
Var check2=SUMX(SUMMARIZE('order','order'[orderid],"order not ok",MAX('order'[Order check not ok line1])),[order not ok]
)
Var check3=SUMX(SUMMARIZE('order','order'[orderid],"order ok",MAX('order'[Order check ok line2])),[order ok]
)
Var check4=SUMX(SUMMARIZE('order','order'[orderid],"order not ok",MAX('order'[Order check not ok line2])),[order not ok]
)
Return
SWITCH(TRUE(),
check1 >= check2,"1","0",
check3 >= check4,"1","0",
Blank()
)
Anonymous , there is only one else
like
SWITCH(TRUE(),
check1 >= check2,"1",
check3 >= check4,"1",
Blank()
)or add additional condition for 0
1 Reply
- amitchandakSuper User
Anonymous , there is only one else
like
SWITCH(TRUE(),
check1 >= check2,"1",
check3 >= check4,"1",
Blank()
)or add additional condition for 0