Forum Discussion

AdamD123's avatar
AdamD123
Icon for Helper I rankHelper I
2 years ago
Solved

Multiplication of two figures

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...
Need Help
  • jgeddes's avatar
    jgeddes
    2 years ago

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

jgeddes's avatar
jgeddes
Icon for Super User rankSuper User
2 years ago

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's avatar
    AdamD123
    Icon for Helper I rankHelper I
    2 years ago

    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's avatar
      jgeddes
      Icon for Super User rankSuper User
      2 years ago

      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's avatar
        AdamD123
        Icon for Helper I rankHelper I
        2 years ago

        Hello,

         

        Is the below sufficent?