Count rows where a Date is in the future

[JonasBI]

Hi everyone,

I am trying to create a measure that counts the rows of a column which has dates in it. 

The measure should only count the rows with dates in the future.

e.g.

this should show an output of 6 since today is the 8th of december 

Also I need another measure that counts all the entries from today and the past

Thanks in advance!

[VijayP · Accepted solution]

@JonasBI  Try this

dates future = CALCULATE(COUNTROWS(Dates),ALL(Dates),Dates[Date]>TODAY())

I have used the datedimension table to count the rows