Forum Discussion

lc1's avatar
lc1
Helper III
6 years ago
Solved

Sum numeric values using filters

Hello, I have two columns PAR_Hours which are numeric values and PAR_Codes which are text values. I need to sum all hours for specific codes (LN, LD and DR) I tried using several versions of this f...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    Hi,

    Try this measure

    =CALCULATE(SUM(Absenteeism[PAR_HOURS]),Absenteeism[PAR_CODE]="LN"||Absenteeism[PAR_CODE]="LD"||Absenteeism[PAR_CODE]="DR")

    Hope this helps.

v-lionel-msft's avatar
v-lionel-msft
Community Support
6 years ago

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.