Calculate average price based on certain condition

Hi Nun ,

Apologies for the delay response.

Calculated column and measure will not give same results. This is because Calculated column computes at row-level in the table whereas a measure is aggregated over a table.

when you use calculated column in visuals (like a table grouped by Customer), Power BI will SUM or AVERAGE those individual values.

The correct way to calculate average in this case is using a measure.

If this doesn’t resolve after checking it, please provide some sample data and expected output so that I will help you to resolve your issue more accurate.

Thank you.