filtering issue

[#1]

I have a field of 5 item. how do i tie each item to a text or button such that if i click on any it will exclude it from  my selections and change the color?

i can also use listbox if its posible to exclude with it

[dsharmaqv]

Create 5 buttons ans variables for values you want to exclude

Set action Set Variable

and in expression right something like

Sum( { < [Department]  = {'*'}-{$(=$(Department01)),$(=$(Department02))}  > } Sales)

[vinieme12]

This will only complicate things unnecessarily , what are you trying to achieve.

Why not stick with a ListBox with selection style as LED Check box,

[Anonymous]

Hi,

Please see attached.

Select 1 or multiple items that you want to exclude and then hit the exclude button.

Button > Actions> Add > select excluded > Field = YourFieldName

Hope this helps!

[#5]

Why i cant use listbox is by default when u select an item it filters based on your selection, what i want is when i select it should exclude the item selected

Clear?

[#6]

This not it. I have a stack bar chart and i have a field holding 5 items in the stack. i want to use a listbox or buttons to select what i wanna see in the stack

[dsharmaqv]

have you tried above solution

[sunny_talwar]

You can try this with list box selection:

If(GetSelectedCount(Item) = 0, Sum(Measure), Sum({<Item = e(Item)>}Measure))

[Anonymous]

Hi Emma,

It should work with a stack as well. See updated app attached.

[vinieme12]

OK, I am trying to understand the use case here

Making an exclusion from a selected field is going to be a two step Process

1) You make the user select a value to exclude

2) You make the user click on another button to confirm the action(Action > Select Excluded )

Another Approach , Is a Single step process for the USER,   Where user makes only one selection and

you modify expressions to exclude selections, like stalwar1‌  has demonstrated below.

Your choice!!