Card with the same information as the Slicer

[PatrickPerovan]

Hello everybody,

I'm using the information from the Card to bring up the information already filtered in Slicer.
However, I can't find any option to bring "All" when all slicers information is selected.

For example, in the case below, I would like the information "All" to show the Card instead of "Canada".

I can't find any kind of quick measure to define this.

[Samarth_18 · Accepted solution]

Hi @PatrickPerovan ,

Please try this:-

Measure =
VAR result =
    CONCATENATEX ( VALUES ( table[Country] ), [Country], "," )
RETURN
    CALCULATE ( IF ( ISFILTERED ( table[Country] ), result, "ALL" ) )

[PC2790 · Accepted solution]

Hey @PatrickPerovan ,

Try this:

ShowSelected = 
if(ISFILTERED(TableName[Country]),CONCATENATEX(Values(TableName[Country]),TableName[Country],","),"All")

Case 1: Only one country selected:

Case 2: Multiple countries selected:

Case 3: None selected:

I hope this is what you are looking for.

[PatrickPerovan]

Legend!

Thank you!

[Samarth_18]

Hi @PatrickPerovan ,

You could create a measure like this:-

Measure =
IF (
    SELECTEDVALUE ( table[Country] ) = BLANK (),
    "ALL",
    SELECTEDVALUE ( table[Country] )
)

BR,

Samarth

[PatrickPerovan]

Hi Samantha, this works in part. 😅

When I select two or more countries, it keeps returning me as ALL.

BR

[Samarth_18 · Accepted solution]

Hi @PatrickPerovan ,

Please try this:-

Measure =
VAR result =
    CONCATENATEX ( VALUES ( table[Country] ), [Country], "," )
RETURN
    CALCULATE ( IF ( ISFILTERED ( table[Country] ), result, "ALL" ) )