Multiply three values (2 from same Table).

[Anonymous]

Hi,

This might be a easy task but since I´m new to BI I would need some help!

I have a table "Export" with two columns "Quantiy" and "Value". I´m using Sumx since I want a calculation on each row and not on the totalts. But since this is in the wrong currency, I need to multiply with my conversion rate. Note that I dont need any lookup on the FX value since I´m using a conversion value. This value is found in the table "Currency" and column "Conversion" and they are linked togheter through a date-table.

My code is:

SUMX('Export Data','Export Data'[productQuantity]* 'Export Data'[productPriceExVAT])

And I need to multiply this value with the conversion rate on each row, since the currency is different each day. 

Regards,

Niclas

[ValtteriN · Accepted solution]

Hi,

You can accomplish this using RELATED:

Export Measure = SUMX('Export Data','Export Data'[Qty]* 'Export Data'[Value]*RELATED(CurrencyRates[Conversion]))

Test Data:

End result:

I hope this helps to solve your issue and if it does consider accepting this as a solution and giving the post a thumbs up!

[Anonymous]

Thanks for the help! I tried this earlier but it didn´t work. The error was in my relationship between the tables!

Regards,

Niclas