Average of Measure in YOY %Change

[Anonymous]

Hello!
I am trying to develop a couple of measures to calculate the YOY %change for multiple properties. The formulas work great for each individual property, but when I select two or all the properties the sum or average of the measures is not correct. I know the measure does not work well in this condition.

Does anyone know if I can modify my formulas and get better results?

TotalNetChange = SUM('Table'[Value])

TotalNetChangeLY = CALCULATE([TotalNetChange],SAMEPERIODLASTYEAR('Calendar'[Date]))

% Change = IF(ISBLANK([TotalNetChangeLY]),BLANK(),(((DIVIDE([TotalNetChange],[TotalNetChangeLY])-1))))

I would like to see an average %change when I select 2 or more properties.

[Ashish_Mathur]

Hi,

Share the download link of the PBI file and show the expected result very clearly.

[Anonymous]

Thank you so much Ashish!
I attached the Power BI and sample spreadsheet. 

I explained what I want in the Power BI file.

Thank you so much for your help!

https://drive.google.com/drive/folders/1dEr4EEQkAJjgPagql9ozLJs8Ni6SbTy6?usp=share_link 

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[Anonymous]

Thank you so much Ashish!
It works now!

[Ashish_Mathur]

You are welcome.