Help with Summing

[Anonymous]

Hello, 

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 2	1	0.2	1	0.2	0.2
Name 3	4	0.8	2	0.8	0.8
Name 4	3	0.6	3	0.6	0.6
Name 5	2	0.4
Total		3.0	6.0	3.0	1.6

[tamerj1 · Accepted solution]

Hi @Anonymous 

please use

Total FTE =
SUMX (
    SUMMARIZE (
        'Global Staff Targets',
        'Global Staff Targets'[# of Days Worked],
        'Global Staff Targets'[Provider Name],
        'Global Staff Targets'[FTE]
    ),
    CALCULATE (
        IF ( [Total Hours] <> 0, SUM ( 'Global Staff Targets'[FTE] ) )
    )
)

[Anonymous]

Thank you!!!!!