Hi guys,
i am struggling with a piece of DAX.
I have 2 tables. [employee] and[access control]. related on empID
I need a measure tht returns how many times an individual occurs in the [accescontrol] table in a given period. returnig 0 if they dont.
eg
employee
| employeeID | Name |
| 1 | George |
| 2 | Lovemore |
| 3 | Sydey |
| 4 | Montgomery |
| 5 | Alecia |
| 6 | Nadia |
| 7 | Ramu |
| 8 | Mark |
| 9 | Sean |
| 10 | Travor |
access control
| EmpID | EventDate |
| 3 | 2021-12-22 |
| 1 | 2022-01-01 |
| 5 | 2022-01-02 |
| 6 | 2022-01-03 |
| 8 | 2022-01-04 |
| 9 | 2022-01-05 |
| 10 | 2022-01-06 |
| 10 | 2022-01-07 |
| 5 | 2022-01-08 |
| 3 | 2022-01-09 |
| 1 | 2022-01-10 |
| 1 | 2022-01-11 |
| 6 | 2022-01-12 |
| 4 | 2022-01-13 |
| 9 | 2022-01-14 |
| 10 | 2022-01-15 |
| 9 | 2022-01-16 |
| 5 | 2022-01-17 |
| 2 | 2022-01-18 |
| 2 | 2022-01-19 |
| 9 | 2022-01-20 |
| 8 | 2022-01-21 |
| 6 | 2022-01-22 |
| 6 | 2022-01-23 |
| 5 | 2022-01-24 |
| 4 | 2022-01-25 |
| 3 | 2022-01-26 |
| 3 | 2022-01-27 |
| 4 | 2022-01-28 |
| 2 | 2022-01-29 |
| 1 | 2022-01-30 |
| 1 | 2022-01-31 |
filter 1
| | 2021-12-22 to 2022-01-31 |
| George | 5 |
| Lovemore | 3 |
| Sydey | 4 |
| Montgomery | 3 |
| Alecia | 4 |
| Nadia | 3 |
| Ramu | 0 |
| Mark | 2 |
| Sean | 4 |
| Travor | 3 |
filter 2
| | 2022-01-01 to 2022-01-10 |
| George | 2 |
| Lovemore | 0 |
| Sydey | 1 |
| Montgomery | 0 |
| Alecia | 2 |
| Nadia | 1 |
| Ramu | 0 |
| Mark | 1 |
| Sean | 1 |
| Travor | 2 |
filter 3
| 2022-01-10 to 2022-01-25 |
| George | 2 |
| Lovemore | 2 |
| Sydey | 0 |
| Montgomery | 2 |
| Alecia | 2 |
| Nadia | 3 |
| Ramu | 0 |
| Mark | 1 |
| Sean | 3 |
| Travor | 1 |
hope thats clear enough?
any ideas
thanks a mil
ian
