Forum Discussion
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 ...
amitchandak
Super User
Super UserChrispate03 , 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?
