Dax error!

[Anonymous]

Hello,I am trying to write a DAX statement which should show the sum of all the tickets with status as opened for the current month. 

Can someone please tell me the syntax for it?

Thanks!

[v-xiaoyan-msft · Accepted solution]

Hi @Anonymous ,

Please try:

 Calculate(sum(value), filter ('table', [status]="opened" && Month([Date])= Month(Today()) ))

Best Regards,
Community Support Team _ Caitlyn

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