Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
locle90
Helper I
Helper I

average measure

Dear All,

I have a problem with the average production revenue in the BI report. I have a need to average sales as below. Value and brand entry daily. Can you help me create a measure to calculate the price that value?

 

BrandRevenue
10500
20300
30800
401000

 

average=(500/total revenue)*10+(300/total revenue)*20+(800/total revenue)*10+(1000/total revenue)*40

 

Thanks

4 REPLIES 4
MattAllington
Community Champion
Community Champion

Averagex(tableName,tableName[Brand] * tableName[Revenue])



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.

Dear Matt,

Thanks for your reply but maybe not right.

Please refer my picture bellow.I have model and KG and i want to see value like that.

 

locle90_0-1602140500706.png

 

Ok, yes. Mine is simple average, yours is the weighted average. I think the following will work

 

SUMX(tableName,tableName[Model] * tableName[KG]/sum([tableName[KG]))



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.

Dear Matt,

Greate.It's can work now.

Thanks so much for your support.

 

Loc Le

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.