I want to create a measure

[NicoHa]

Hello,

I’m new at Power BI and would appreciate your help with a measure.

I have a data table with a date and the name of the employee who worked that day (only 1 employee works per day).

I would like to create a measure that counts the number of days within any given time period that each employee worked.

For example, say I have the following data table:

Date	Employee
1/01/2022	Alain L.
2/01/2022	Wouter B.
3/01/2022	Alain L.
4/01/2022	Alain L.
5/01/2022	Virgil P.
6/01/2022	Wouter B.

I would like to create a visual using a measure showing the number of days each employee worked, like this:

Visual - Days worked
Employee	Jan	Feb	Mar
Alain L.	12	10	14
Wouter B.	8	9	6
Virgil P.	10	11	9

I know I have to drop employee into columns on the visual, Year/Month into column and that measure into value.

Which measure I have to create?  Thanks in advance.

[Jayee · Accepted solution]

Hi @NicoHa ,

you don't need a measure for count simply use employee field in values and aggregate it to count thats it.

if you really want to create measure use below one

employee count = count(table[employee])

 If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!