Forum Discussion

Chrispate03's avatar
Chrispate03
New Member
2 years ago

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. 

 

 

Any help would be greatly appreciated! 

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    2 years ago

    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

    • Chrispate03's avatar
      Chrispate03
      New Member
      2 years ago

      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?