Count values excluding particular time

[jeongkim]

Hi,

How can I not count or Cancel Time between 00:00am to 06:00am? 

[ajaybabuinturi · Accepted solution]

Hi @jeongkim,
I am asuming your asking about a DAX logic to not count the rows b/w 00:00am to 06:00am. You can try with below logic.

Cancel Count Daytime =
CALCULATE(COUNTROWS('TableName'),
    FILTER('TableName', HOUR('TableName'[Cancel Time]) >= 6)
)

Thanks,
If you found this solution helpful, please consider giving it a Like👍 and marking it as Accepted Solution✔. This helps improve visibility for others who may be encountering/facing same questions/issues.