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

#### Back to School Contest

Engage and empower students with Power BI!

#### Watch Sessions On Demand!

Continue your learning in our online communities.

#### Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Top Kudoed Authors
Users Online
Currently online: 110 members 1,558 guests
Recent signins: