Filter based off of 2 conditions

[jcastr02]

I'd like to be able to remove (filter out) any values where the # of Coachings and # Headcount is equal to 0 in Both.  See screen shot below, if they have 0 in both columns I'd like to exclude.  I can put the filter for one of those, but I want it for both.  Note both values are measures.  Thank you.

[Arul · Accepted solution]

@jcastr02 ,

Can you create new measure to filter out those 0's from the visual? By applying that new measure at visual level filter you can get rid of 0's.

Filter Measure = 
IF(AND([Test Measure 1] = 0,[Test Measure 2] = 0),0,1)

Thanks,