cancel
Showing results for
Did you mean:
connork Helper I

## Calculated Measure Totals

DAX is not exact here (actual data much messier) but example as follows:

Goal: get subtotal of overtime hours by employee AND dept as of as of 5/2/17 (assume DATA1 ends here)   Data sets:

Data1: actual hours by employee by day

REF1: working days list by date

REF2: employee standard working hours per day

Calculated Measures

FTE%  = IFERROR( REF2[STD_HRS]/8,0)

REGHRS = REF1[WORKDAY] * 8 * [FTE%]

OT HRS = IF(  CALCULATE(SUM(DATA1[HOURS]) - [REGHRS]>0,   CALCULATE(SUM(DATA1[HOURS])-[REGHRS],  0)

Result: Subtotals/grand totals for OT hrs are calculating based on subtotals, need sum of above. Any help on how to change the OT Hrs measure to correctly get subtotals is appreciated

1 ACCEPTED SOLUTION

Accepted Solutions
scottsen Memorable Member

## Re: Calculated Measure Totals

The standard technique for "my subtotals are wrong" is "wrap it in a sumx".

Total OT=SUMX(Employees, [OT Hrs])

Since [OT Hrs] is correct on a per employee basis, you can just walk all employeeds adding up their OT Hrs...

scottsen Memorable Member

## Re: Calculated Measure Totals

The standard technique for "my subtotals are wrong" is "wrap it in a sumx".

Total OT=SUMX(Employees, [OT Hrs])

Since [OT Hrs] is correct on a per employee basis, you can just walk all employeeds adding up their OT Hrs...

Announcements #### Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section. #### ‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products. Top Solution Authors
Top Kudoed Authors
Users online (768)