Forum Discussion
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...
Hi,
Try this measure
=CALCULATE(SUM(Absenteeism[PAR_HOURS]),Absenteeism[PAR_CODE]="LN"||Absenteeism[PAR_CODE]="LD"||Absenteeism[PAR_CODE]="DR")
Hope this helps.
Thank you, it worked!
You are welcome.