Calculating average of a numeric value across unique column values

[AdamRobC]

Hi, I have what I believe is a fairly simple use case but struggling to get the right DAX.

I would like to create a column that calculates the average Current Price by retailer and product ID e.g. for the below table extract the value for rows where Retailer = Zalando (CZ) would be 12.19 ((13.46 + 10.60 + 12.52) / 3)

The full table includes multiple product IDs as well so would need to work across retailers and product IDs.

I've tried various solutions involving AVERAGEX, SUMMARIZE etc. but nothing has worked for me

Thanks!

[Greg_Deckler · Accepted solution]

@AdamRobC I believe there are two approaches to this that should work. Approach 1:

Column = CALCULATE(AVERAGE('Table'[Current Price])

Uses row to filter context switching.

Approach 2:

Column = AVERAGEX(FILTER('Table',[Retailer] = EARLIER('Table'[Retailer]) && [Retailer Product ID] = EARLIER('Table'[Retailer Product ID)),'Table'[Current Price])

[AdamRobC]

Option 2 works! Thanks Greg