Measure calculating difference from average?

[seanlim]

Hi there, I'm realtively new to PowerBI and I'm hoping someone here can help me out.

I am trying to create a measure that gives me the difference of AvgpriceTM from the total average price. 

i.e. (65 - 15.50)...(42-15.50) etc.. Any help would be greatly appreciated! 🙂

[amitchandak · Accepted solution]

@seanlim ,

You need a measure like an example

Average(Table[Price]) - calculate(Average(Table[Price]) , allselected())

or

Average(Table[Price]) - calculate(Average(Table[Price]) , all())

[seanlim]

This worked, thanks so much!