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.

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.

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.