Sum numeric values using filters

Try

CALCULATETABLE(VALUES(Absenteeism[PAR_HOURS]),filter(Absenteeism,Absenteeism[PAR_CODE] in {"LN","LD","DR"}))
OR
CALCULATETABLE(VALUES(Absenteeism[PAR_HOURS]),filter(all(Absenteeism),Absenteeism[PAR_CODE] in {"LN","LD","DR"}))

Hi lc1 ,

Try this measure:

Measure=
CALCULATE(
    SUM(Absenteeism[PAR_HOURS]),
    FILTER(
        Absenteeism,
        Absenteeism[PAR_CODE] in {"LN", "LD", "DR"}
    )
)

OR

Measure1=
CALCULATE(
    SUM(Absenteeism[PAR_HOURS]),
    FILTER(
       ALL(Absenteeism),
        Absenteeism[PAR_CODE] in {"LN", "LD", "DR"}
    )
)

"MdxScript (Model 8, 37)...A table of multiple values was supplied where a single value was expected."

VALUES(Absenteeism[PAR_HOURS]) will return a single column table, however, you what you created is a measure, so the program reports an error.

VALUES() function 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.