cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

## weighted average for groups

Hi, I have simple calculation, that I thought would work with filtering, but I can't get it to work. My data:

Table1

I thought that my formula for result fieldwould work when slicing with groups but it doesn't.

`Result = (Table1[Value] / sum(Table1[Value]) * Table1[X])`

Correct results calculated with excel are -13.333 for group A and -35.5556 for group B. I assume that my sum functions doesn't work in filtering but how do I write this that weight part is only calculated for grouped part?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft

## Re: weighted average for groups

Hi @viitama,

```Result =
SUMX (
Table1,
CALCULATE (
MAX ( Table1[Value] )
/ CALCULATE ( SUM ( Table1[Value] ), ALLEXCEPT ( Table1, Table1[Group] ) )
* MAX ( Table1[X] )
)
)```

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
Microsoft

## Re: weighted average for groups

Hi @viitama,

```Result =
SUMX (
Table1,
CALCULATE (
MAX ( Table1[Value] )
/ CALCULATE ( SUM ( Table1[Value] ), ALLEXCEPT ( Table1, Table1[Group] ) )
* MAX ( Table1[X] )
)
)```

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.

Announcements

#### August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

#### July 2020 Community Highlights

Learn about the exciting things that happened in July.

#### Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

#### Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors
Top Kudoed Authors