Forum Discussion

Malsha's avatar
Malsha
Helper I
2 years ago

matrix visual columns issue

Hi, I have created a matrix as below. I'm using the below measure to get the values for selected dates. Total Worked Hours = Var cal = CALCULATE(     SUM('timesheet_data'[Hours Worked...
Need Help
AmiraBedh's avatar
AmiraBedh
Super User
2 years ago

Can you try the following : 

 

Total Worked Hours =
var cal =
CALCULATE(
    SUM('timesheet_data'[Hours Worked]),
    'timesheet_data'[Timesheet Job Role Name] IN {"Morning Cleaning", "Janitors", "Window Cleaner", "Duty & Morning", "Supervisor"},
    'timesheet_data'[duration] <> "S",
    'timesheet_data'[duration] <> "H"
)

return
IF(ISBLANK(cal), 0.00, cal)
  • Malsha's avatar
    Malsha
    Helper I
    2 years ago

    Hi AmiraBedh,
    I tried that measure but it also gives the 0.00 as value for all the dates.

    • AmiraBedh's avatar
      AmiraBedh
      Super User
      2 years ago

      Can you please provide some of your dataset ?