Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
Solved! Go to Solution.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
100%
thnks so much
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
User | Count |
---|---|
139 | |
70 | |
67 | |
52 | |
52 |
User | Count |
---|---|
210 | |
92 | |
64 | |
59 | |
56 |