Forum Discussion

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

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