Issue with cell values showing no value, but subtotal are correct for “last 12 month” measure

[Piratheban123]

Hi there!

So I have this issues with a matrix in my Power BI report, where if I use a date filter/slicer for my 12 month measures, it won’t show the proper row value for the given date.

So to clarify if I have values for a row named “spendings” on every month except March 2020, and I chose March as my start month based on a filter, the row will be empty, but the subtotal/total for the category will be correct. If I chose April 2020, it will properly show the value for the last 12 month period.

Any suggestions on how to fix this?
I have looked at the relationship between my tables, and they all seem to be fine.

My measure is the following:

12 month measure =
Calculate(
Sum(“table name” [column name]),
DATESINPERIOD(“date table name”[date], MAX (‘date table name’[date]),-12, MONTH))

My "date" column is in the format of yyyy-mm, and I use this as my slicer for the matrix

Best regards,

PIratheban

[Pragati11]

Hi @Piratheban123 ,

You will need to add more details screenshots here.

Refer following blog to see how can provide more information on your query:

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Thanks,

Pragati