I have a table of Presence of certain employees at certain events.
for each event it will list the eventnumber and employee name in a row.
Richt now in the report i just count the occurences and it tells me for each employee how many events they attende within a filtered period of time.
The problem occurs when i try to list how may employees have attended how many events.
|# of events||# of employees|
We need this data because they are required to attend certain amount of events in a given period. this will help us track how many have not completed it.
Optimaly i find a sollution that still allows me to filter based on Time periods.
I have been looking at measures but I can't manage to get the correct output.
Thanks in advance.
Solved! Go to Solution.
The numbers shown in the result table seems wrong. the number of people who attended 3 events should be 0. Please show the expected result very clearly.
Hi @tproost ,
I created some data:
Here are the steps you can follow：
Set [Employee] to Count (Distinct)
Measure = var _mindate=MINX(ALLSELECTED('Table'),[Date]) var _maxdate=MAXX(ALLSELECTED('Table'),[Date]) return CALCULATE( DISTINCTCOUNT('Table'[Employee]), FILTER(ALL('Table'),'Table'[Event]=MAX('Table'[Event])))
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly