Case statement In Power Bi Dax

[Anonymous]

Hello All,

I have a calculate field in Tableau and Need to convert in Power Bi DAX.

Could any one please help how to write below in power bi

Here Region is my field.

I kept this in slicer and showing select All Option also.

In below formula Overall means select all in slicer.

Formula :

case [Region]

when 'Overall' then if
[Department]='Hyd' or
[Department]='Del' or
[Department]='Unknown' then 'Level1'
elseif
[Department]='Service Desk' then 'International Service Desk'
elseif [Department]='Service Desk India' then 'ISD India'
END
when 'ES' then IF
[Department]='Hyd' or
[Department]='Del' or
[Department]='Unknown' then 'Level1'
END
when 'ESI' then IF
[Department]='Service Desk' then 'ISD'
elseif [Department]='Service Desk India' then 'ISD India'

END
end

[Tahreem24 · Accepted solution]

@Anonymous Try this:

Calculated Column = SWITCH(TRUE(),
TableName[Region]="Overall" && TableName[Department] in {"Hyd","Del","Unknown"},"Level1",
TableName[Region]="Overall" && TableName[Department] = "Service Desk", "International Service Desk",
TableName[Region]="Overall" && TableName[Department] = "Service Desk India", ISD India",
TableName[Region]="ES" && TableName[Department] in {"Hyd","Del","Unknown"},"Level1",
TableName[Region]="ESI" && TableName[Department] = "Service Desk", "ISD",
TableName[Region]="ESI" && TableName[Department] = "Service Desk India", "ISD India"
)