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.

lc1's avatar
lc1
Icon for Helper III rankHelper III
6 years ago

Thank you, it worked!

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

You are welcome.