I need some help with figuring out how to get a something to sum properly please.
I would like a column in the table to sum if a measure is not 0, so I would like the below Table Column FTE to sum up if the Measure Total Hours is not 0.
I have been using this:
Total FTE = IF('Report Measures'[Total Hours] <>0, SUM('Global Staff Targets'[FTE]))
Can anyone please help me?
|Table Column||Table Column||Table Column||Measure||What I get||What I want|
|Provider Name||# of Days Worked||FTE||Total Hours||Total FTE||Total FTE ?|
|Name 1||5||1|| || || |
|Name 5||2||0.4|| || || |