Change a column of a table based on a filter

[amirabedhiafi]

I have a filter containing City/Country :

I created a table Filters with a column Filtering containing City and Country like above.

When selecting City I want to display the target by city: 

When selecting Country I want to display the target by country: 

Knowing that I have other filters in the same page like semester ...

[Anonymous · Accepted solution]

Hi  @amirabedhiafi ,

Here are the steps you can follow：

1. Use Enter data to create a table.

2. Create measure.

City =
IF(
    CONTAINS(
        'Table',
        'Table'[Slicer Selection],"City"),
        SUMX(FILTER('Filters','Filters'[City]=MAX('Filters'[City])),'Filters'[Target]),BLANK())

Country =
IF(
    CONTAINS(
        'Table',
        'Table'[Slicer Selection],"Country"),       SUMX(FILTER('Filters','Filters'[City]=MAX('Filters'[City])&&'Filters'[Country]=MAX('Filters'[Country])),'Filters'[Target]),BLANK())

3. Use Table's [Slicer Selection] as the slicer

4. Result:

When choosing City as:

When choosing Country as:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[aj1973]

Hi @amirabedhiafi 

Do you know how to use bookmarks? I would recommend it.

[amirabedhiafi]

Yes just tried to use a trick with the filters instead of the bookmarks.

[aj1973]

Well try with Bookmarks now,

Put 2 visuals on top of each others, select the filter, and depending on filter selection hide or keep the visual you need to see using bookmarks.

here is a video that could help you

https://www.youtube.com/watch?v=_Afcj8mT5_Q