Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not 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()
	)

 

 

 

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Anonymous , there is only one else

 

like

 

SWITCH(TRUE(),

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

Blank()
)

 

or add additional condition for 0

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@Anonymous , there is only one else

 

like

 

SWITCH(TRUE(),

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

Blank()
)

 

or add additional condition for 0

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.