Compare daily actual values against targets that are defined based on the day of the week

[Anonymous]

Hello Power BI gurus,

Looking for help in achieving the following. Thank you akready for the support.

1. I have list of employees who post Hours on daily basis. 

2. The maximum total hours per day are based on the day of the week for ex: monday to friday are 8 hr, and sat-sun 0 hr. I am creating a separate mapping table to store this value.

3. I want to compare the actual hours Vs the max hours.

The final DAX measures I am looking for is:

Count of number of days per month per person when Actual Hours > Max Hours

Count of number of days per month per person when Actual Hours < Max Hours

Also, if possible can I do conditional formatting based on these criteria?

Given data

Date	Weekday	Person	Actual Hours
Monday, June 1, 2020	Monday	P1	8
Tuesday, June 2, 2020	Tuesday	P1	9
Wednesday, June 3, 2020	Wednesday	P1	8
Thursday, June 4, 2020	Thursday	P1	8
Friday, June 5, 2020	Friday	P1	7
Saturday, June 6, 2020	Saturday	P1	0
Sunday, June 7, 2020	Sunday	P1	0
Monday, June 8, 2020	Monday	P1	6
Tuesday, June 9, 2020	Tuesday	P1	8
Wednesday, June 10, 2020	Wednesday	P1	8

Comparison table

Weekday	Max Hours
Monday	8
Tuesday	8
Wednesday	8
Thursday	8
Friday	7
Saturday	0
Sunday	0

[AllisonKennedy · Accepted solution]

Use your DimDate table to filter by month, and try

MEASURE= COUNTROWS(FILTER(GivenData, GivenData[ActualHours]>RELATED(CompTable[MaxHours])))