Forum Discussion
if else statement in dax function
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
6 Replies
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
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
