Error in Distinct Count

[HMUTUAL01]

I am trying to set up a KPI to count the people that match a certain criteria but an getting an error in expression.  Is there a way to get this into a KPI?

Error message: "Nested Aggregation not allowed"

=Count(distinct IF(MAX(NFILE_DATE)='$(=max(NFILE_DATE))'), Emp_num)

[Lisa_P · Accepted solution]

Try this:

=Count(distinct {<NFILE_DATE={"$(=max(NFILE_DATE))"}>} Emp_num)

[HMUTUAL01]

That worked, thanks!