cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

## Sum of Average

Hi All,

I have a column in a table with below expression

AVERAGEX(VALUES('VW_PRS_LifeCycleState2'[LifeCycleState]),CALCULATE(AVERAGE(VW_PRS_LifeCycleState2[Target_Round2])))

I need to have the total displayed with SUM of "Average" of all the detail rows. The above expression is working fine for Average in detail rows while total is not correct. Currently total as well is doing the average while i need the SUM of averages.

Thanks

Gaurav

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft

## Re: Sum of Average

Hi @GM17,

Please create a measure with below formula:

```Average =
SUMX (
VALUES ( 'VW_PRS_LifeCycleState2'[LifeCycleState] ),
AVERAGE ( VW_PRS_LifeCycleState2[Target_Round2] )
)```

Best regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 REPLIES 4
Highlighted
Resolver III

## Re: Sum of Average

@GM17 go to the data

Create the New Column & Enter the Function

`SumofAverage =AVERAGEX(VALUES('VW_PRS_LifeCycleState2'[LifeCycleState]),CALCULATE(AVERAGE(VW_PRS_LifeCycleState2[Target_Round2])))`

Create New Column

`Column =  [SumofAverage ]`

if you find any difficulty share the sample data

Regards,

Chetan K

Highlighted
Microsoft

## Re: Sum of Average

Hi @GM17,

Please create a measure with below formula:

```Average =
SUMX (
VALUES ( 'VW_PRS_LifeCycleState2'[LifeCycleState] ),
AVERAGE ( VW_PRS_LifeCycleState2[Target_Round2] )
)```

Best regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Helper I

## Re: Sum of Average

Hi Yuliana Gu,

i am also looking for the similar type of solution , i have tried but no luck .can you please have a look on it.

https://community.powerbi.com/t5/Desktop/Sum-of-Average/m-p/288894#M127118

thanks,

Highlighted
Helper I

## Re: Sum of Average

Hi

strange, but for some reason it works here is such a formula

Measure = AVERAGEX(VALUES('table'[name]);SUM('table'[values]))

Announcements

#### August Community Highlights

Check out a full recap of the month!

#### August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

#### Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors