How to change the values of a KPI based on filters?

[Furblos]

Hey Guys,

I have a problem related to my dashboard.

I have two main KPIs, one is for people still active, the second one is for people who are going to retire.

My problem is that when I filter people who are going to retire, I wanna hide or show the value of 0 in the KPI (the one with active people)

How can I do that? 

Thanks in advance!

[Lauri]

Try this as the expression for the active KPI, if you want it to be empty when you select retiring people:

If(GetSelectedCount([Retiring])>0, Null(), Count([Active]))