Kpi issue

[Upew]

Hello all great community 🙂

I have a table with 2 columns

customer id and product.

i have a bar chart that count the number of customer that bought each product.

i have a kpi with the next expression:

=count({<customer={"=count(distinct product)=getselectedcount(product)"}>} distinct customer)

this kpi is counting the customer that bought a combination of product that i choose from the barchart.

next, i'm trying to create a filter pane with a specific values from the product  column with the next expression:

=if(wildmatch(product,'*forhome*'),product)

and the filter is showing the correct values that i want.

my problem is that when i choose a product from the filter pane i made, my kpi isnt working.

when i choose a product from the barchart the kpi is working good, but when i choose it from the filter pane its not working.

any idea how can i fix this?

thanks alot!!!!!