Count distinct duplicating figures

[#1]

Hi,

I have 2 data sets that are hooked together by Staff_Name.

distinct(Staff_Name) is counting exactly double the number of staff.

What is the reason for the double count as the data model is hooked together on the Staff_Name?

thanks

Stuart

[#2]

The correct syntax is count(distinct Staff_Name)

[#3]

Thanks Jacob.

This still produces a double count again.

If I load in one or the other data set I only get half the figure, but when both are loaded I get the double count

[#4 · Accepted solution]

Are they exactly the same in both data sets?

[#5]

Good catch - there was a missing underscore in one side of the data !

Thanks again