weighted average

[Giada_Togliatti]

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

[Jihwan_Kim · Accepted solution]

Hi, @Giada_Togliatti 

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] )

)

Or, please share your sample pbix file's link here.

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

https://www.dropbox.com/s/yksotb4f2mkmbj3/giadav2.pbix?dl=0 

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.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

[Giada_Togliatti]

perfect, thank you!

[amitchandak]

@Giada_Togliatti , Try a measure like

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

[Giada_Togliatti]

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

What I need is another value: 5,70