Calculate returns blank for some subcategory

romas876 — Thu, 04 Aug 2022 16:45:20 GMT

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

Re: Calculate returns blank for some subcategory

daXtreme — Thu, 04 Aug 2022 21:15:18 GMT

Not enough info to troubleshoot.

topic Re: Calculate returns blank for some subcategory in DAX Commands and Tips

Calculate returns blank for some subcategory

Re: Calculate returns blank for some subcategory