Error Message When Creating New Measure

[CraigSchulz]

While creating a new measure, the following code worked just fine until I added the last filter within 'Calculate', then I got the error message shown below. I'm not sure how to correct this, or where to find the table filter the message indicates. Can someone help me understand what is happening here?

[Ashish_Mathur]

Hi,

Paste the formula in the body of the message.  I will make the correction.

[CraigSchulz]

Okay, Thanks.

AvgParkedByNoon = CALCULATE(
SUM(SMSYTD[ParkedByNoon])/DISTINCTCOUNT('Calendar'[Date]),
'Calendar'[IsHoliday]=FALSE(),
'Calendar'[Day of Week]=[DoWtoday]
)

[edhans · Accepted solution]

CALCULATE filters cannot use measures by themselves. You'd need to use a FILTER() function there.

AvgParkedByNoon = CALCULATE(
SUM(SMSYTD[ParkedByNoon])/DISTINCTCOUNT('Calendar'[Date]),
'Calendar'[IsHoliday]=FALSE(),
FILTER('Calendar','Calendar'[Day of Week]=[DoWtoday])
)

So without loading this in and testing it, the above should work. See this article for more info on why FILTER is sometimes necssary within CALCULATE.