Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Calculate Average

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    
Formula
Jos_Woolley's avatar
Jos_Woolley
Icon for Solution Sage rankSolution Sage
5 years ago

Hi,

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

Regards