question

GilMichael-7316 avatar image
0 Votes"
GilMichael-7316 asked ·

Calculating Average with exception to values with zeros

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:
8681-arp.jpg



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-supported
arp.jpg (47.5 KiB)
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

DSPatrick avatar image
0 Votes"
DSPatrick answered ·

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

https://community.powerbi.com/


--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.




· Share
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.