Slicer not showing the right filtered values

[rajaurora]

Hello

I have a situation where i have location , department as slicers and a table with departments and Headcount
all come from same table . When i chose the location , the department and headcount  shows in the table as 3 rows and numbers are correct as headcount  but the slicer for the department shows 6 values 

if i remove the headcount from the table it shows 6 rows like slicer
I used the calculation for headcount as

Headcount = CALCULATE(SUM(‘All’[CNT]),FILTER(‘All’,[Withinrange]=1))

where the Withinrange is

Withinrange =
VAR Cond =
IF(SELECTEDVALUE(‘All’[ADJ_HIRE_DATE]) <= [Harvest] &&
SELECTEDVALUE(‘All’[TERM_DATE]) > [Harvest],
1,
0
)
RETURN
Cond

The customer is asking whey more slicer values for departments are showing if they pick up the location

Not sure why location slicer is not filtering the right way on Department slicer

Any help on this is appreciated.

[Greg_Deckler]

@rajaurora Because your Headcount is only returning a value for certain departments and for the other departments it is returning BLANK and blanks are, by default, automatically filtered from table visualizations. It's a feature.

[rajaurora]

Is it possible to create a Department where  Headcount is not blanks and use it as a slicer ?