Unable to Apply Filter to Measure

Lisa Callahan · 2025-04-09T15:58:23+00:00

There was an error rendering this rich post.

I am trying to use DatePart in a custom expression in Visualizer but keep getting the dreaded 'Unable to Apply Filter to Measure' error. I thought DatePart was the correct syntax to use but I must have lost my mind somewhere along the way…

This is the expression -

[Check Date: Sum: Time Record Item Hours] WHERE INTEGER(DatePart(Year,[Payroll Register Items.Check Date]))='2024'

I have tried with and without the INTEGER option. Same error.

Any assistance is always appreciated :)

Find more posts tagged with

Accepted answers

Dan_Rosen

[Check Date: Sum: Time Record Item Hours] WHERE [Time.Year] = 2024

It's been a long morning 😂

All comments

Dan_Rosen

Have you tried removing quotes from '2024'?

Dan_Rosen

You should also be able to use [Time.Year] in the where

Lisa Callahan

I did, no dice. But I do feel like it is something easy that I am just missing.

Dan_Rosen

[Check Date: Sum: Time Record Item Hours] WHERE [Time.Year] = 2024

It's been a long morning 😂

Lisa Callahan

OMG my heart is singing right now…

THANK YOU :)