cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Tumbleweed
Helper II
Helper II

Slicer - Need help with calculated column or measure

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")

 

1 ACCEPTED SOLUTION
MahyarTF
Solution Sage
Solution Sage

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

View solution in original post

2 REPLIES 2
MahyarTF
Solution Sage
Solution Sage

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

I rebuilt the whole model, thanks for advice!

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Show episode 9

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 26

New Date - Check it Out!

Mark your calendars and join us on Thursday, October 6 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors