cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
9192gks
Helper III
Helper III

Multiple IF statements inside switch case

I have multiple statements that i need to validate for "category" column.
I have written this DAX but i am getting an error "Switch doesnot support comparing values of type boolean with text ,consider using value or format to convert one of the values"
Category =
var cat_raw = 'Data'[Category_Raw]
var new = SWITCH (
TRUE (),
IF(AND('Data'[Facility] starts with "AB",OR('Data'[Payer] contains ="XXXX",
'Data'[Payer] contains = "XYXY")), "XContainer","XService"),
IF(AND('Data'[Facility] = "BC",OR('Data'[Type]="YYYY",
'Data'[Type]="YXYX")), "YContainer",cat_raw),
IF(AND('Data'[Facility] = "CD",'Data'[Type]="CDCD"),
"DContainer", cat_raw),
cat_raw
)
return new
1 ACCEPTED SOLUTION
AlB
Super User III
Super User III

Hi @9192gks 

the first part has random non-DAX code like "starts with". For the secodn part, you'd need something like this. You'll probably have to adapt it a bit but you'll get the idea.

Category =
VAR cat_raw = 'Data'[Category_Raw]
VAR new =
    SWITCH (
        TRUE (),
        AND (
            'Data'[Facility] = "BC",
            OR ( 'Data'[Type] = "YYYY", 'Data'[Type] = "YXYX" )
        ), "YContainer",
        AND ( 'Data'[Facility] = "CD", 'Data'[Type] = "CDCD" ), "DContainer",
        cat_raw
    )
RETURN
    new

 Look at the syntax of SWITCH to understand well how it works

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

SU18_powerbi_badge

 

View solution in original post

5 REPLIES 5
V-pazhen-msft
Community Support
Community Support

@9192gks 

Can you explain with a short sample table, so we can understand the code. 

 

Regards
Paul

AlB
Super User III
Super User III

@9192gks 

1) Let me see the actual code.

2) Check that none of the columns you are comparing to text are of type boolean

 

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

SU18_powerbi_badge

 

All my columns are of type TEXT, i have checked it already

AlB
Super User III
Super User III

Hi @9192gks 

the first part has random non-DAX code like "starts with". For the secodn part, you'd need something like this. You'll probably have to adapt it a bit but you'll get the idea.

Category =
VAR cat_raw = 'Data'[Category_Raw]
VAR new =
    SWITCH (
        TRUE (),
        AND (
            'Data'[Facility] = "BC",
            OR ( 'Data'[Type] = "YYYY", 'Data'[Type] = "YXYX" )
        ), "YContainer",
        AND ( 'Data'[Facility] = "CD", 'Data'[Type] = "CDCD" ), "DContainer",
        cat_raw
    )
RETURN
    new

 Look at the syntax of SWITCH to understand well how it works

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

SU18_powerbi_badge

 

View solution in original post

Sorry about the non dax part, it was for my understanding which i will do it later , to search and to use contain in dax query .So for the time being i am using "=" only , and i also tried removing the IF statements and i am still getting the same error

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors