Forum Discussion

kelly008's avatar
kelly008
Helper I
4 years ago
Solved

Multiplication Between Columns in the same table

Hello,   I am currently trying to multiply two columns in the same table, but when I do I get the wrong total's at the bottom or the wrong line data depending on the formula's I've tried to use.  ...
Need Help
  • SpartaBI's avatar
    SpartaBI
    4 years ago

    kelly008 I think you mean you want to do something like that:

     

    MEASURE = 
SUMX(
     'RelProdOrderComponents',
     'RelProdOrderComponents'[Expected_Quantity] *
     'RelProdOrderComponents'[Unit_Cost])
)

     


    Showcase Report – Contoso By SpartaBI


          

kelly008's avatar
kelly008
Helper I
4 years ago

So.... Both are just columns from the RelProdOrderComponent.

 

Summarisation wise:

 

 

 

SpartaBI's avatar
SpartaBI
Community Champion
4 years ago

Great! It's just SUM, so I have no clue 🤣, I will PM you