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


          

SpartaBI's avatar
SpartaBI
Community Champion
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

Hi,

 

Thanks for replying, when I use the code you have provided I get this:

 

Oddly, If I take the last bracket out I get this:

Which basically just adds in another column that has the same value as column 'Test2 CustomColumn'.