Calculating Average with exception to values with zeros

Gil, Michael 1 Reputation point

Hi PBI Community,

I am looking to calculate an average across some pricing values to get an Average Retail Price (ARP). The problem i'm running into, I am getting ARP values that are dividing pricing values with zero in them. See in the example below:

I need my formula to return the average of the Base and Promo price value, but only populate the base price for the ARP if the promo price value is zero.

  • My measure:
    ARP = ('Data Summary'[Base Price]+'Data Summary'[Promo Price])/2

Any help is greatly appreciated! Thanks!

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
25,392 questions
No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Dave Patrick 341.5K Reputation points MVP

    QnA currently supports the products listed here (more to be added) Better to reach out to subject matter experts in dedicated forums over here.

    --please don't forget to Accept as answer if the reply is helpful--


    Regards, Dave Patrick ....
    Microsoft Certified Professional
    Microsoft MVP [Windows Server] Datacenter Management

    Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.