OTBI: How do I use a non fact column in the Column Filter.

Summary

OTBI: How do I use a non fact column in the Column Filter.

Content

Hi,

I have a requirement where i need to use a non-fact column which is Standard Working Hours in a Filter criteria of a Column level filter.

For ex: I want to use it like this: Below I am trying to convert the Standard Working Hours into INT and then use it in filter.

SUM(FILTER(CAST("Worker"."Standard Working Hours" AS INT) USING ( (
"Worker"."Standard Working Hours"<36) AND ("Worker"."Employee Hire Date" < CAST( '2020-04-06' AS DATE)) 
) ))

I am expecting to sum up the  Standard Working Hours only where the  Standard Working Hours < 36 and Employee Hire Date < 2020-04-06.