Apply filter with button in analysis

[Federicofkt]

Hi,

I need to create a button that filters out a specific product from all the measures.

like: measure for items sold = 100, I'd like that button to behave like a filter in the measure (e.g.: Type -= {'Car'}).

I've set a button with the "select value from field action", then set the field and then put the value in:
Type <> {'Car'} but it's not working.

What I need is the button to behave like I have the filter box, I select "car" and then I select the excluded ones.

Thanks!

[Padma123]

Hi,

Exclude values in one field then do it load script

like if(Type='Car',1,0)as new_field;

after In button select value in field(select new_field ,value=0)

[Bhushan_Mahajan]

@Federicofkt Follow below process.

1. Create one variable with value as 1

2. Take a button chart create two Actions with name Car and Others as below.

3. Then Write expression in your measure as =if($(vPD)=0,sum({<A-={'Car'}>}Sale),Sum(Sale))