Load just specific data

[gwmills_fiserv]

I am creating a chart with branches as my dimension across the bottom.  I want to limit the dimension to show all branches except branch 500 and branch 600.   I do not wan this to be a filter, as I the user to be able to select specific branches for further details, but when the filter is cleared, I want to continue to exclude numbers 500 and 600.

[OmarBenSalem · Accepted solution]

change ur measure from :
sum(Measure)
to
sum({<Branch-={'500','600'}>}Measure)

[gwmills_fiserv]

It is not a measure, but rather the dimension across the bottom.

[OmarBenSalem]

an u share your chart?

Chart type?

Dimensions and measures used?

and an image maybe?

[gwmills_fiserv]

Sure.   

Combo Chart.   Bottom is Branch, Left Side Balance, Right side Rate info.

[dplr-rn]

Solution mentioned by Omar will work and using set analysis (i.e. giving logic in expressions) is the best approach Unless some other restriction which we i dont know of.

Or you can use if condition on the dimension level on chart as well but i wouldn't recommend it