cancel
Showing results for
Did you mean:
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
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...

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.

#### MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

#### ‘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