Forum Discussion

dharish20240911's avatar
dharish20240911
New Member
1 year ago
Solved

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...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi dharish20240911 

     

    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.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi dharish20240911 

 

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.