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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous .

    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

  • 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