Calculate Average

[Yau0101]

Dear All,

Please advise how do i calculate the sum of average price for product G20 below. 

The Average price should be $112.4 

Thanks

[Jos_Woolley]

Hi,

MyMeasure =
CALCULATE ( AVERAGE ( 'Table'[price] ), 'Table'[Product] = "G20" )

Regards

[SanketBhagwat]

Hi @Yau0101 .

Use measure as

Sum Average Price=CALCULATE(SUM('Table'[Average Price($]),'Table'[Product]="G20")

OR 
Sum Average Price=CALCULATE(SUM('Table'[Average Price($]),FILTER('Table','Table'[Product]="G20")

If this post helps, then please mark it as 'Accept as Solution' so that other users could find it easily.

Regards,

Sanket Bhagwat