cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
jhd Regular Visitor
Regular Visitor

Show filter of another column

 

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"
)
 
 
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

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Show filter of another column

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"
)

1.png

Regards,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Community Support Team
Community Support Team

Re: Show filter of another column

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"
)

1.png

Regards,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
jhd Regular Visitor
Regular Visitor

Re: Show filter of another column

Thanks @v-cherch-msft !