How to show SELECT ALL in filter selection

[Anonymous]

Hi, I have the below code which will gives me the filter selection criteria when I select each of them but I would like to show "Select ALL" when I select all from the filter.

Filetr Values= 

VAR MaxFilters = 30

RETURN

IF (

ISFILTERED ( Sale[countryName] ),

VAR ___f = FILTERS ( Sale[countryName] )

VAR ___r = COUNTROWS ( ___f )

VAR ___t = TOPN ( MaxFilters, ___f, Sale[countryName] )

VAR ___d = CONCATENATEX ( ___t, Sale[countryName] , ", " , Sale[countryName],ASC)

VAR ___x = "Country = " & ___d

& IF(___r > MaxFilters, ", ... [" & ___r & " items selected]") & "; "

RETURN ___x & UNICHAR(13) & UNICHAR(10)

)

Please any suggestion would be appriciated.

Thank you,

[v-chuncz-msft · Accepted solution]

@Anonymous 

You may change it as follows.

    IF (
        ISEMPTY (
            EXCEPT ( ALL ( Sale[countryName] ), ALLSELECTED ( Sale[countryName] ) )
        ),
        "Select ALL",

[Anonymous]

HI @Anonymous ,

Put your calculated field in the filter visual and change the setting from the format pane: Turn it On 

( screenshot below)

Hope this helps you.

Thanks,

Tejaswi