Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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)
@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))