Forum Discussion
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. ...
kelly008 I think you mean you want to do something like that:
MEASURE = SUMX( 'RelProdOrderComponents', 'RelProdOrderComponents'[Expected_Quantity] * 'RelProdOrderComponents'[Unit_Cost]) )
Hi, just to add on here, although there is a red tick next to the total, it still isnt right even though the number is more realistic than 600 million. Sorry if that confuses anything.
ok wait 🙂 in your visual, excpected qunatity and unit cost are implicit measures right? You just added the columns there, right? What is the summarization of these columns? SUM / AVERAGE / Something else?