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 ...
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
Anonymous , refer the new column code above
