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 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")
Need Help
  • 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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    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