cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Post Patron

## weighted average

Hi,

I have this sample dataset:

I need to calculate a weighed average in power bi:

Media pesata is a calculated column:

media pesata = Foglio1[Punteggio]*Foglio1[Peso]

Instead of 2,85, I need to have as result tue sum of media pesata divided by the sum of media peso (in this case:3,60+2,10)/1=5,7
How can I do?
Thank you
1 ACCEPTED SOLUTION
Super User

Please try something similar to the below.

I tried to create a sample pbix file similar to yours.

Dedia pestata total fix =
IF (
ISFILTERED ( 'Table'[Category] ),
[Media pestata],
SUMX ( VALUES ( 'Table'[Category] ), [Media pestata] )
* SUMX ( VALUES ( 'Table'[Category] ), [Peso Avg] )
)

The link below is my sample pbix file's link.

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Visit my LinkedIn page by clicking here.

Schedule a meeting with me to discuss further by clicking here.

4 REPLIES 4
Super User

Please try something similar to the below.

I tried to create a sample pbix file similar to yours.

Dedia pestata total fix =
IF (
ISFILTERED ( 'Table'[Category] ),
[Media pestata],
SUMX ( VALUES ( 'Table'[Category] ), [Media pestata] )
* SUMX ( VALUES ( 'Table'[Category] ), [Peso Avg] )
)

The link below is my sample pbix file's link.

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Visit my LinkedIn page by clicking here.

Schedule a meeting with me to discuss further by clicking here.

Post Patron

perfect, thank you!

Super User

@Giada_Togliatti , Try a measure like

divide(sum(Table[Foglio1[Punteggio]), sum(table[media pesata]))

Post Patron

@amitchandak , it doesn't work, it gives me this result:

What I need is another value: 5,70

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors