Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Help with Summing

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...
  • tamerj1's avatar
    tamerj1
    4 years ago

    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] ) )
    )
)

     

tamerj1's avatar
tamerj1
Community Champion
4 years ago

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] ) )
    )
)