How do I count rows with date less than today using direct query

[CCAIXE]

Hi, 

how do i count rows whit date lass then today using direct query?

[v-yuezhe-msft]

@CCAIXE,

You connect to your data source using "DirectQuery" mode, right? If so, create a measure in your table using the DAX below.

Measure = CALCULATE(COUNTROWS('TableName'),FILTER('TableName','TableName'[Date]<TODAY()))

Regards,