if else statement in dax function

[Anonymous]

Hello All,

I have a tableau dashboard where I have parameter having values like US and Canada,APAC and Overall.

And I have department values like Central,Georgia,Hyd and Pune

My requirement is If I select region as US and Canada then I need to show only Central,Georgia

                               If I select region as APAC then I need to show only Hyd,Pune

                                If I select region as Overall then I need to show All 4.i.e, Central,Georgia,Hyd,Pune

Below is my logic in Tableau and I am not sure how to write in power BI as I am new.

Could some one help how to write

I created a table inside power BI for the parameter values and not sure how to write after that

CASE [Region]
when 'US and Canada' then
[Department] = 'Central' or
[Department]= 'Georgia'
when 'APAC' then
[Department] = 'Hyd' or
[Department]= 'Pune'

when 'Overall' then
[Department] = 'Central' or
[Department] = 'Georgia' or
[Department]= 'Hyd' or
[Department] = 'Pune'
END

[amitchandak]

@Anonymous , Can you please share sample data and sample output in table format?

I provided a solution on this topic last time, seems like that did not work for you. So need sample

[Anonymous]

Yes @amitchandak ,

As per your solution whenever I select US and Canada or APAC its not showing the respected departments that we writeen in the logic.

As per your dax function I am getting only regions instead of the department names

Sample Data :

Department	Sales
Central	100
Georgia	200
Hyd	300
Pune	400

Table I created in Power BI:

Region Names

US and Canada

APAC

Thats why I posted again

[amitchandak]

@Anonymous , You do not need a table you need a column. If you have that table join with this column

Switch( True() ,

[Department] in {"Central","Georgia"} , "US and Canada",

[Department] in {"Hyd","Pune"} , "APAC",

"Other"

)

If this does work, Please share the final outcome on tableau

[Anonymous]

Hi @amitchandak ,

Below is what I am expecting .

In the DAX you mentioned above you are not using the table I created inside power BI for regions.

[Anonymous]

Hi @amitchandak ,

Could you please help on this

[amitchandak]

@Anonymous , refer the new column code above