Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

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 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 ColumnTable ColumnTable ColumnMeasureWhat I getWhat I want
Provider Name# of Days WorkedFTETotal HoursTotal FTETotal FTE ?
Name 151   
Name 210.210.20.2
Name 340.820.80.8
Name 430.630.60.6
Name 520.4   
Total 3.06.03.01.6
1 ACCEPTED SOLUTION
tamerj1
Super User
Super User

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

 

View solution in original post

2 REPLIES 2
tamerj1
Super User
Super User

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
Not applicable

Thank you!!!!!

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.