Slicer - Need help with calculated column or measure

[Tumbleweed]

Dear Community,

I have to show weekly hour length in a slicer. I used the following DAX

that doesn't have any affect on the matrix. How I can create interactive measure/CC for the slicer? Thank you

Weekly OT Length =

SWITCH(

TRUE(),

'Table'[Measure Weekly OT Hours]< 2, "< 2 Hours",

'Table'[Measure Weekly OT Hours] >2, ">= 2 Hours")

[MahyarTF · Accepted solution]

Hi,

According to your shared file, there isn't any active relation between 'Hours Per Week 1' and 'Table' and also the other relations direction are to the particular tables, so we don't expect could filter the destination table based on the measure in other (no relational) table.

Please find the other design for your data model to create the relation (or active the inactive ones).

Appreciate to Kudos

[Tumbleweed]

I rebuilt the whole model, thanks for advice!