Set Analysis forces chart to display data disregarding filters

[tschullo]

I have run across this issue before:

I have a chart that shows data for restricted by set analysis in the expression definition, for example:

Sum({<Category={"A","B"}>} Sales)

If a user then uses a filter to attempt to only display Category A, the chart ignores the filter.

My solution has always been to add a new field in script that captures those two categories as one, for example CatAB='Y'.
I can then modify the expression to Sum({<CatAB={"Y"}>} Sales) and now it respects the user filtering by Category.

Is there no other simpler way to handle this?  I'm still not clear on why set analysis behaves this way.  Seems a bit overbearing.

[Digvijay_Singh]

not sure but try this may be - 

Sum({<Category={'A','B'}>*<Category=P(Category)>} Sales)

[Clever_Anjos · Accepted solution]

Add a star before the = sign

Sum({<Category*={"A","B"}>} Sales) 

[tschullo]

Thanks!