topic Re: Calculate average of percentage price changes instead of change of the average price in DAX Commands and Tips

Calculate average of percentage price changes instead of change of the average price

00Kevin00 — Tue, 25 Feb 2025 15:37:45 GMT

Hey community,

I have the following problem:

For a list of products (here ISBN) I have two measures which give me the MIN and MAX Prices for a selected time period.
Based on these measures, I calculate the the Period-over-Period percentage change via the following DAX Measure

PoP %-∆ = VAR Part1 = DIVIDE([Price for MAX_Date],[Price for MIN_Date]) RETURN IF(Part1=BLANK(),BLANK(),Part1-1)

However, for the total, I don't need the change of the average price, but the average of the percentage price changes.

Could someone help me with that?

Re: Calculate average of percentage price changes instead of change of the average price

Greg_Deckler — Tue, 25 Feb 2025 16:15:40 GMT

00Kevin00 First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e

This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8

Re: Calculate average of percentage price changes instead of change of the average price

Anonymous — Wed, 26 Feb 2025 06:26:49 GMT

Hi 00Kevin00

You may try creating a new measure like this

new measure = DIVIDE ( SUMX ( VALUES ( 'Table'[ISBN] ), [PoP %-∆] ), COUNTROWS ( VALUES ( 'Table'[ISBN] ) ) )

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

Re: Calculate average of percentage price changes instead of change of the average price

00Kevin00 — Thu, 27 Feb 2025 16:41:52 GMT

Hey Jing, thanks for your reply.

I'm almost there - as you can see in my screenshot, [PoP %-∆] contains Blank rows, which should not be counted into the average calculation (but 0%, do). Could you adjust the formula so that it counts only the ISBNs where [PoP %-∆] is not blank?

Thank you so much!

Re: Calculate average of percentage price changes instead of change of the average price

00Kevin00 — Thu, 27 Feb 2025 16:47:25 GMT

Found the solution 🙂

new measure = DIVIDE( SUMX( FILTER( VALUES('Table'[ISBN]), NOT(ISBLANK([PoP %-∆])) ), [PoP %-∆] ), COUNTROWS( FILTER( VALUES('Table'[ISBN]), NOT(ISBLANK([PoP %-∆])) ) ) )