count days<7 hours

[Anonymous]

I would like to  create a measure that would count the number of days by person that has less than 7 hours. I'm also looking at a specific time frame. 11/1/2020-10/31/21. 

Thank you

Date	Name	Hours
2020-11-01	Jan	7.20
2020-11-01	Jane	0.10
2020-11-01	Luke	1.80
2020-11-01	Mike	4.30
2020-11-01	Steve	6.10
2020-11-01	Tom	3.40
2020-11-02	Jan	8.20
2020-11-02	Jane	4.70
2020-11-02	Luke	10.00
2020-11-02	Tom	30.00
2020-11-02	Blake	2.90

[Jihwan_Kim · Accepted solution]

Days count less than 7 hours : =
IF (
HASONEVALUE ( Names[Name] ),
COUNTROWS ( FILTER ( RELATEDTABLE ( Data ), Data[Hours] < 7 ) )
)

Link to the sample pbix file