DAX Measure to show count for previous month

[Anonymous]

I've created a measure to show the count of accidents that occurred the previous month using the DAX below:

Count_Accidents_Previous Month = CALCULATE([Count_Accidents], PREVIOUSMONTH('Date'[Date]))

This works find in a table when you have a Month in as a column:

But I want to be abe to show it on a card (as I can with Year To Date), and currently this doesnt work, just comes up blank:

Here is the DAX I used for Year to Date:

Count_Accidents_Y2D = CALCULATE([Count_Accidents], YEAR('Date'[Date]))

Can't work out why I cant get it to work in a card for Previous Month

[v-deddai1-msft]

Hi @Anonymous ,

Did you have any slicer for date or month?

Best Regards,

Dedmon Dai

[amitchandak]

@Anonymous , this because you have not filtered or selected a month in the slicer.  In that case, the All-time intelligence function will till the end of time in the date you supplied and calculate the time back. So Looking at the table it giving NOV