measure for today's date

[JImcon90]

Hi, 

I'm wanting to create a measure for today's date. 

Measure = COUNT('DB - GSH'[Id] = TODAY()) as expected doesn't work. 

thanks

[v-xiaotang · Accepted solution]

Hi @JImcon90 

-

Try this.

measure for today = CALCULATE ( COUNT('DB - GSH'[Id]), FILTER(All('DB - GSH'), 'DB - GSH'[StartDate] = TODAY())))

Besides, can you add more information or PBI file after removing sensitive information?

-

Best Regards,

Community Support Team _ Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[PaulDBrown]

@JImcon90 

Try:

measure for today = CALCULATE ( COUNT('DB - GSH'[Id]), FILTER( Table, Table [Date] = TODAY())))

(adjust the table and column syntax to your model)

[JImcon90]

Cheers, I tried ... 

measure for today = CALCULATE ( COUNT('DB - GSH'[Id]), FILTER( DB-GSH, DB-GSH [StartDate] = TODAY())))

but no luck