Measure "If filter = (All) then show "All" else show filter value"

[Danny_Stultiens]

Hi people,

For a report that is used by different production plants, I'm able to filter pages per site (with bookmarks). I have a card in the page that shows the current filtered plant name by showing the field value "First [Plant]".

Some users want to see the page showing data from all plants combined. When I remove the filter on plant to show all plants, all values on the page show the correct data, but the card with the plant name shows the first plant name alphabetically (of course). 

I would like to use a measure that shows the plant name if the filter is active, and shows the value "All" if the filter is inactive, showing all plants combined. I was trying with the if function and searched the forum, but unfortunatly did not find the exact answer I'm looking for.

Can someone please push me in the right direction? Thanks a lot in advance!

With kind regards,

Danny

[Anonymous · Accepted solution]

Hey @Danny_Stultiens 

The measure that you are using in card visual can be something like this to fullfil your requirement:

FilteredValue =
IF (
ISCROSSFILTERED ( 'First [Plant]' ),
SELECTEDVALUE ( 'First [Plant]' ),
"ALL"
)

Please accept it as a solution if it matches your requirement🙂

[Anonymous · Accepted solution]

Hey @Danny_Stultiens 

The measure that you are using in card visual can be something like this to fullfil your requirement:

FilteredValue =
IF (
ISCROSSFILTERED ( 'First [Plant]' ),
SELECTEDVALUE ( 'First [Plant]' ),
"ALL"
)

Please accept it as a solution if it matches your requirement🙂

[Danny_Stultiens]

Thank you for your quick reply.

Exactly what I was looking for! Works like a charm.

[Anonymous · Accepted solution]

Hey @Danny_Stultiens 

The measure that you are using in card visual can be something like this to fullfil your requirement:

FilteredValue =
IF (
ISCROSSFILTERED ( 'First [Plant]' ),
SELECTEDVALUE ( 'First [Plant]' ),
"ALL"
)

Please accept it as a solution if it matches your requirement🙂