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

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

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