Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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.
Any help would be greatly appreciated!
@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
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?