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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
Chrispate03
New Member

URGENT! Calculating Average Of Service Types using 2 columns of data (Paid Amount, and Weight)

Good morning,

 

I am fairly new to Power BI and am struggling to create a calculation to get the average cost per lb for each service type using the data from the paid amount and weight columns. I have tried watching multiple videos to figure this out, but still am not sure how to accomplish this. Can someone please help! Below is a screen shot of the data that I am using. 

 

Chrispate03_0-1697033835689.png

 

Any help would be greatly appreciated! 

2 REPLIES 2
amitchandak
Super User
Super User

@Chrispate03 , a new measure

 

calculate(Divide(Sum(Table[paid amount]), Sum(Table[weight Billied])) , allexcept(Table, Table[Service Type]))

 

or

 

 

calculate(Divide(Sum(Table[paid amount]), Sum(Table[weight Billied])) , filter(allsected(Table), Table[Service Type] = max(Table[Service Type] )))

 

Learn Power BI: All, allselected, removefilters,allexcept- https://www.youtube.com/watch?v=cN8AO3_vmlY&t=24270s

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Thank you for assisting. If I wanted to also show this aveage cost per lb across different Periods for each service type how would I do that?

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors
Top Kudoed Authors