Forum Discussion
DAX Measure error
- Anonymous3 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 TeamIf 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
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