Calculate returns blank for some subcategory

[romas876]

Hi All,

I am having an issue with my calculate formula and hope you can help.

The formula returns blank for some subcategories and works fine for others.  The category totals are fine, however, some subcategories are blank. Also I have noticed this when I try to calculate monthly totals for a prior year.

See below screenshot

The calculate formula 

CALCULATE([Total Cases], FILTER(ALL('Date Table'), YEAR('Date Table'[Date]) = CompareYear && MONTH('Date Table'[Date]) = CurrentMonth && 'Date Table'[Date] <= WKDAY))

Where CompareYear is the selected benchmark year users select, and

WKDAY is the comparative workday in the selected year

Thank you

[daXtreme]

Not enough info to troubleshoot.