Forum Discussion
dharish20240911
1 year agoNew Member
Filtering the drop slicers
Example : I have three dropdown slicers titled as : 1)Region , 2) Country , 3) City When user select "Asia" from 1st dropdown(Region) then dynamically only related options (Countries in Asia) sh...
- Anonymous1 year ago
Currently, the dax function can not recognize place names, and if you can't join the relationships, you can only manually add calculated columns, for example:
Here's a sample able:
Table3;
Add a calculated column:
Country = SWITCH ( TRUE (), 'Table3'[City] IN { "Delhi", "Mumbai", "Hyderabad", "Chennai" }, "India", 'Table3'[City] = "Beijing", "China", 'Table3'[City] = "London", "Europe", BLANK () )Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
dharish20240911
1 year agoNew Member
They are different tables and have no relationships , they all are dimensinal tables connected with fact table.