manager and leader insights
2 Topics
Manager Effectiveness PowerBI report (No Manager 1:1 definition)
Can someone from microsoft help me understand why the Powerbi report which calculates a rolling four week average only uses 2 weeks to calculate if a person has met with their manager in the code below. Is the intent to show %of people not meeting with their manager at least once a week? So if an organization wants to show how many people met with their managers at least once in the last four week I would need to adjust the base metric ([_Meetings with manager 1 on 1 last 2 weeks]) to look at last 4 weeks instead of 2 weeks correct? % of employees with no 1:1 with their manager - rolling 4 weeks = VAR LogicTest = '_All Measures'[BT_Slicer_4w_Rolling_Average] VAR __REPORT_FIRST_DATE = '_All Measures'[First date all] VAR __date = SELECTEDVALUE ( 'Manager effectiveness query'[MetricDate] ) VAR __last_4_week = DATESINPERIOD ( 'Manager effectiveness query'[MetricDate], __date, -28, DAY ) VAR metric = AVERAGEX ( __last_4_week, VAR __numerator = CALCULATE ( COUNT ( 'Manager effectiveness query'[PersonId] ), 'Manager effectiveness query'[_Meetings with manager 1 on 1 last 2 weeks] = 0 ) VAR __denominator = CALCULATE ( COUNT ( 'Manager effectiveness query'[PersonId] ) ) RETURN DIVIDE ( __numerator, __denominator, 0 ) ) RETURN IF ( LogicTest && __date >= __REPORT_FIRST_DATE + 21, IF ( [Num Of Employees] >= SELECTEDVALUE ( 'Minimum group size'[Minimum group size] ), metric ), BLANK () )Solved467Views0likes1Comment
