Show filter of another column

[jhd]

To remind users of what filters (in this case, suppliers) they have selected, I use the following measure:

IF(

ISFILTERED(Golden_Suppliers[GROUP_SUPPLIER]),

CONCATENATEX(

FILTERS(Golden_Suppliers[GROUP_SUPPLIER]),

Golden_Suppliers[GROUP_SUPPLIER],", "),

"ALL"

)

(Thanks to @OwenAuger  on this post: Text field to show the selected filter)

The results of which are displayed within a card.

The table "Golden_Suppliers" looks like this:

GROUP_SUPPLIER            GID

Acme Corporation           ACM

Handmade Stuff              HAS

Things Innovative            THI

I frequency use the GID within visuals because they are more compact. The problem is that when a user uses a drillthrough based on the GID the above measure does not see that the Golden_Supplier table has been filtered and continues to show the result "ALL".

Is there a way to fix this?

Thanks, James

[v-cherch-msft · Accepted solution]

Hi @jhd 

You may try below measure:

Measure =
IF (
    ISFILTERED ( Golden_Suppliers[GROUP_SUPPLIER] )
        || ISFILTERED ( Golden_Suppliers[GID] ),
    CONCATENATEX (
        VALUES ( Golden_Suppliers[GROUP_SUPPLIER] ),
        Golden_Suppliers[GROUP_SUPPLIER],
        ", "
    ),
    "ALL"
)

Regards,

[jhd]

Thanks @v-cherch-msft !