Show zero instead of blank, but maintain filters

[MCornish]

I have seen this asked a lot and the accepeted response is always Measure + 0, or an IF statement, or something along those lines.

However this give me an issue

If I start with this table, you can see that the 3 employees in IT have taken no sick days.

If I add the measure to add in the scoring system I would get a blank. Do what is suggested and I get a zero but the filter gets ignored.

What I need it to do is show a zero but not overide the filter placed on it

[amitchandak · Accepted solution]

@MCornish , Try something like this.  an new measure

if(max(table[Dept-Employee]) in values(table[Dept-Employee]) , [Measure]+0, blank())

[measure] is your existing measure

[venudhar]

Really helpful

[MCornish]

Dude you are a genius