Multiplication of two figures

[AdamD123]

Hello,

I would like to find the total value of our stock. To do this I have our inventory and the unit cost of that inventory, for each item. I just need to multiply the two numbers, however when I have done this it is multiplying the total inventory by the sum of the unit cost. 

I need the total to just be the sum of Inventory x Unit Cost, if that makes sense - when I have done this in Excel I get the correct figure of ~135,000. I think I need to stop it from muliplying the sum of but unsure how I do this?

Any help is greatly appreciated.

Kind regards,

Adam

[jgeddes]

In this case you could likely use SUMX to get the result you are looking for.

SUMX(
'Item_Card',
'Item_Card'[Inventory] * 'Item_Card'[Unit_Cost]
)

[AdamD123]

Hello, thank you for advising. I have done this but the number is still showing incorrect - I think the advised calculation would work but I need to exclude (filter) sum of the codes out. How would I do this to ensure those codes are excluded from the calculation?

[jgeddes]

Can you share some sample data, the measure you are using and the result you are getting? From there I should be able to pinpoint the issue.

[AdamD123]

Hello,

Is the below sufficent?

[jgeddes · Accepted solution]

What does your measure return for a total value if you put it in the table visual?

[AdamD123]

Hello,

When I add that to the table, that is showing correct. I have now turned that into the card view and it is showing correclty.

Thank you ever so much for your help!