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
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'.

 



  • SpartaBI's avatar
    SpartaBI
    Community Champion
    4 years ago

    kelly008 you had a bracket down down below 🙂
    Anyway, so I didn't understand what you want to achieve.
    Can you share the visual you have without testing and just the column of the desired result by drawing the logic and the expected number.
    Also, Expected_Quantity] and [Unit_Cost] are they measures or columns? If measures what are they?
    Is [description] a key in your table or a value that represnet multile rows?
    Can you share also a screenshot of the data model table