Forum Discussion

mbhunt's avatar
mbhunt
Regular Visitor
9 years ago
Solved

Divide two columns in a group by.

Sorry, I know this seems so simple, but I can’t figure it out.   In the following example, how do I take the [ListPriceExtended] and divide it by the [Qty] to get the [AverageListPrice] for each li...
  • mike_honey's avatar
    mike_honey
    9 years ago

    I think I know where you went wrong - did you add AverageListPrice as a "New measure" or a "New column"?  It looks like "New column", but it should likely be a "New measure".

mbhunt's avatar
mbhunt
Regular Visitor
9 years ago

Thanks for the reply. 

 

So is "SUM" supposed to take the Sum of the entire table or just the group by section (which is what I want)?

 

Thanks.

mike_honey's avatar
mike_honey
Icon for Memorable Member rankMemorable Member
9 years ago

I think I know where you went wrong - did you add AverageListPrice as a "New measure" or a "New column"?  It looks like "New column", but it should likely be a "New measure".

  • Mike_Carlo's avatar
    Mike_Carlo
    Icon for Most Valuable Professional rankMost Valuable Professional
    9 years ago

    I think Mike has nailed it..   I made a simple demo and made a calculated column and measure.  The column reprecates your what your seeing, but the measure actually meets your requirements.

     Try remaking your calculation as a new measure:

     

     

     

     

     

     

     

     

     

    Mike Carlo

    www.PowerBI.Tips

    [email protected]

  • mbhunt's avatar
    mbhunt
    Regular Visitor
    9 years ago

    Looks good.  I think I got it.  Thanks.