Forum Discussion

PamelaAG's avatar
PamelaAG
Frequent Visitor
5 years ago
Solved

Dynamic Text showing slicer selection(multiple selection) and "NA" when nothing is selected

Hi All, 

 

I am being trying to create a new measure to show the multiple slicer selection as a dynamic text and to show "NA" when nothing is selected.

 

I tried to use this DAX and it is working, I am getting the countries I selected but when I clear the filter, then I get ALL countries in the dynamic text. How can I get the text  "NA" when there is no selection.

 

Selected Country = "Country Selected: " & IF (
ISCROSSFILTERED ('Table'[Country_Name]),
CONCATENATEX ( VALUES ('Table'[Country_Name]]), ('Table'[Country_Name]]),"," ))
 
Thank you so much in advance!
Pamela
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi PamelaAG 

     

    Use this = "Country Selected:- "&if(isfiltered(countryname),concatenatex(values(Country),country name,","),"NA")

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi PamelaAG 

     

    Use this = "Country Selected:- "&if(isfiltered(countryname),concatenatex(values(Country),country name,","),"NA")