How to DistinctCount?

[#1]

Hello

I have a fact table including answers to a survey by employee.

I have an expression =COUNT(EmploiyeeID) which will give me # of answers.Answers is the most granular level, so for a given EmployeeID I might have up to 5 records, which makes up to 5 EmployeeIDs (same EmployeeID).

In my solution, I would like to count number of Employees and not answers.

So If I count 5 "answers" I would like to have a metric giving 1 "employee".

Is there a way to accumplish this?

Thanks in advance

[MayilVahanan · Accepted solution]

Hi

Try like this

=Count(Distinct EmployeeID)

Hope it helps