Multiply 2 column, put result in the new one. And result is incorrect.

[panj]

Multiply 2 column, put result in the new one , name 'Total, and the result is incorrect.

I have to choose 'Don't summarize' to show correct result, the second one is correct for each lines.

What if I have to show Total, anything I could do besides chooses 'Dont' summarize'?

Thank you in advance.

[amitchandak]

You can also create a new column in you table

total = 'PQ Archived'[QTY] * 'PQ Archived'[Unit Cost (LCY)]

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on Linkedin

[MartynRamsden · Accepted solution]

Hi @panj 

Try this measure:

Total = 
SUMX(
    'PQ Archived',
    'PQ Archived'[QTY] * 'PQ Archived'[Unit Cost (LCY)]
)

Best regards,
Martyn

If I answered your question, please help others by accepting it as a solution.

[panj]

@MartynRamsden  it works now, thank you so much!