Forum Discussion

ckyin999's avatar
ckyin999
Frequent Visitor
1 year ago
Solved

Calculation with the missing the attendance data

Hello everyone, I need to create a report that shows how many staff members meet the monthly target of entering the office ( swipe card record) at least 8 times per month. Additionally, I need to ca...
Need Help
Bmejia's avatar
Bmejia
Super User
1 year ago

Create following measures.  Create a Date table (Calendar table and link to table2 on date).  Also for Logistic Department I see them show as 50% in final output.  In the sample provided they never swiped card only IT and Facilities.

Total Staff = CALCULATE(COUNTROWS('Table'))

Not Meet Target =

VAR BadgeCount = CALCULATE(COUNTROWS(Table2))

VAR Met = IF(BadgeCount>7,1,0)

RETURN

If(MET=0,[Total Staff],[Total Staff]-MET)

MET % = DIVIDE([Not Meet Target]-[Total Staff],[Total Staff],0)


 

 

 

ckyin999's avatar
ckyin999
Frequent Visitor
1 year ago

Hi Bmejia,

 

Thanks for your response.

It worked based on the sample data provided. However, when I pulled in more data, I noticed different results.

For example: The Change Management department has 9 staff members, but only 2 met the target in June & July. The measurement result, however, is showing 8 instead of 7 in both months.  I can't figure out what is the problem.