Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

DAX Measure error

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 ...
  • Anonymous's avatar
    Anonymous
    3 years ago

    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