Help!!!! Deadline approaching!! Formula to identify the current hour

[Anonymous]

I am attempting to use this calculated column as a filter so i can use it conjuction with a similar formula for "count today" 

the "Count today" is working but "is this hour" work with it. Any suggestions?

Count Today =

CALCULATE ( [Count of ID],'Date'[Date]=TODAY() )

IS This Hour =

VAR NotifcationHour =

HOUR( NotificationData[Notification_Time] )

VAR ThisHour =

HOUR( NOW ())

RETURN

IF ( ThisHour = NotifcationHour, "yes", "no" )

[PattemManohar · Accepted solution]

@Anonymous Can't see any issue with your formula...

Create a New Measure as below to count the CurrentHourFlag

Test259 = COUNTX(FILTER(Test259CurrHour,Test259CurrHour[CurrentHourFlag]="Yes"),Test259CurrHour[CurrentHourFlag])