DistinctCount by month

[lab]

I have a table and would like to see distinctcount of employee ID's by month.  I tried DistinctCount but it gave me the same values across all months.

Name	Emp ID	Dept	Sub	OT hours	Month
Employee 1	234	A	A1	4	Jan
Employee 2	235	B	A2	8	Feb
Employee 3	236	C	A3	9	Mar
Employee 1	234	A	A1	12	April
Employee 2	235	B	A2	10	Mar
Employee 3	236	C	A3	11	Feb
Employee 1	234	A	A1	1	Mar
Employee 2	235	B	A2	2	April
Employee 3	236	C	A3	3	Mar
Employee 4	237	D	A4	3	Jan
Employee 1	234	A	A1	3	Feb
Employee 2	235	B	A2	2	Mar
Employee 3	236	C	A3	1	April
Employee 4	237	D	A4	1	Jan

[vojtechsima · Accepted solution]

Hi, @lab 
Simply create a visual where you put months and ID of employes as DistincCount.