cancel
Showing results for
Did you mean:
Frequent Visitor

## Multiply measure by column and sum total

Hello All,

I have read the other discussions on this topic and am still having issues with my report.

I am trying to create a measure (or column) which will multiply Hours by Average ESR (15 * 96.14) for each row and then sum the total cost. Have tried to follow other suggestions but am ready to give up. Any help appreciated.

Thank you

1 ACCEPTED SOLUTION

Accepted Solutions
Super User

## Re: Multiply measure by column and sum total

HI @sr001

I am not sure... but please give a SHOT to this MEASURE

```MEASURE=
IF (
SUM ( '001'[Hours] ) * AVERAGE ( 'ESR Rates'[ColumnName] ),
SUMX (
CALCULATE ( SUM ( '001'[Hours] ) )
* CALCULATE ( AVERAGE ( 'ESR Rates'[ColumnName] ) )
)
)```
3 REPLIES 3
Super User

## Re: Multiply measure by column and sum total

HI @sr001

I am not sure... but please give a SHOT to this MEASURE

```MEASURE=
IF (
SUM ( '001'[Hours] ) * AVERAGE ( 'ESR Rates'[ColumnName] ),
SUMX (
CALCULATE ( SUM ( '001'[Hours] ) )
* CALCULATE ( AVERAGE ( 'ESR Rates'[ColumnName] ) )
)
)```
Frequent Visitor

## Re: Multiply measure by column and sum total

That has worked perfectly, your help is much appreciated.

I see (and think I understand the need for) that you have used SUM and SUMX, but what is the requirement for the HASONEVALUE line please.

Again, many thanks for your help.

Super User

## Re: Multiply measure by column and sum total

Hi @sr001

Sorry for late reply... i was out of work

Actually ....it happens frequently with MEASURES that the sum of individual rows do not match the TOTAL ROW.

Check this precious post of @Greg_Deckler..

http://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/m-p/63376#U63376

HASONEVALUE lets you specify different formula for individual rows and the Total row

Announcements

#### Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

#### Community News & Announcements

Get your latest community news and announcements.

#### Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Top Kudoed Authors
Users Online
Currently online: 6 members 1,523 guests
Recent signins: