Calculating average of a numeric value across unique column values
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!
