Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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

  • Anonymous , there is only one else

     

    like

     

    SWITCH(TRUE(),

    check1 >= check2,"1",
    check3 >= check4,"1",

    Blank()
    )

     

    or add additional condition for 0