how to get the cost each for summarize field

[PBI_newuser]

Hi,

When i have the table with all the line numbers & part numbers (TableA), the "cost each" and "total part cost" are showing the correct amount.

But, when i remove Line Number (TableA1), the cost each for Part Number is incorrect.

How to fix this?

TableA:

TableA1:

[HotChilli · Accepted solution]

Powerbi applies an aggregation in the field well - in this case it's a numeric field so the default is SUM.  You can write your own measure or change the aggregation to MIN or AVG (either should work in this case)

[PBI_newuser]

Hi @HotChilli Thank you! It works!