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 ok, try this:

 

 

MEASURE = 
SUMX(
     VALUES('RelProdOrderComponents'[Description]),
     CALCULATE(SUM('RelProdOrderComponents'[Expected_Quantity]) *
     CALCULATE(SUM('RelProdOrderComponents'[Unit_Cost]))
)

 

 


Showcase Report – Contoso By SpartaBI


      

kelly008's avatar
kelly008
Helper I
4 years ago

Hi,

 

So this goes to the other method that I tried in 'Test2 CustomColumn' where it appears to get the total right but not the row data:

 

As you can see, the line with the red X is not calculating correctly, it should be doing 18 * £334.24 which is £6016.29 (If you look at the column TEST 1, you can see the correct row values) and not £1894.24.