Forum Discussion

lc1's avatar
lc1
Icon for Helper III rankHelper 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.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

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"}))
lc1's avatar
lc1
Icon for Helper III rankHelper III
6 years ago

It didn't work, got an error:

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