DAX Measure error

[Anonymous]

Hi Experts

I am trying to write a dax measure where if the user selects country name from either the Slicer and or table visual by clicking that particular country then show the selected country name in a card visual. if nothing is selected then ALL

Measure (nolt working) - the slicer selection work but not when selecting country from stand table visual

Filter Selected =

        IF(ISFILTERED(pg_control_cases[country]),""&CONCATENATEX(FILTERS(pg_control_cases[country_dim.country_name]),pg_control_cases[country_dim.country_name],", ")) &

                IF(

                   NOT(ISFILTERED(pg_control_cases[country_dim.country_name])),

                "ALL")

[Anonymous · Accepted solution]

Hi @Anonymous ,

The values in the table should be visible in the filtering context, try using VALUES() instead of FILTERS().

Filter Selected =
IF (
    ISFILTERED ( pg_control_cases[country] ),
    ""
        & CONCATENATEX (
            VALUES ( pg_control_cases[country_dim.country_name] ),
            pg_control_cases[country_dim.country_name],
            ", "
        )
)
    & IF ( NOT ( ISFILTERED ( pg_control_cases[country_dim.country_name] ) ), "ALL" )

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum