Help with Summing

Question

Hello,&nbsp;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.&nbsp;&nbsp;I have been using this:&nbsp;Total FTE = IF('Report Measures'[Total Hours] &lt;&gt;0, SUM('Global Staff Targets'[FTE]))&nbsp;Can anyone please help me?&nbsp;Table ColumnTable ColumnTable ColumnMeasureWhat I getWhat I wantProvider Name# of Days WorkedFTETotal HoursTotal FTETotal FTE ?Name 151&nbsp;&nbsp;&nbsp;Name 210.210.20.2Name 340.820.80.8Name 430.630.60.6Name 520.4&nbsp;&nbsp;&nbsp;Total&nbsp;3.06.03.01.6

tamerj1 · Accepted Answer

Hi&nbsp;Anonymous&nbsp;please use&nbsp;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] &lt;&gt; 0, SUM ( 'Global Staff Targets'[FTE] ) )
    )
)&nbsp;

Forum Discussion

Help with Summing

2 Replies

Related content

Running sum

Filtering a Sum

Improper Sum with slicer

SUM

Summing by Client

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