Lookup Measure issues

[Anonymous]

Hi Team,

I have 2 tables.

Table 1 stores FX rates. Table 2 stores the customer, currency and sales. 

I want a measure that looks up currency from Table 2 into currency from Table 1, returning the rate and then dividing by the sales. 

So for West Ham it would be: 6,000/0.7567

I have done it through Power Query M, but I want to improve my measure writing skills and am stuck. 

Table 1:

Currency	Rate
EUR	1
GBP	0.7567
USD	1.123

Table 2: 

Customer	Currency	Sales
West Ham	GBP	6,000
Fulham	EUR	8,945
Chocolate	USD	7,890

[az38 · Accepted solution]

Hi @Anonymous 

try to just create relationships between tables with [Currency] field and then measure like

= DIVIDE( SUM('Table 2'[Sales]), SUM('Table 2'[Rate]) )

[Anonymous]

Thanks @az38 !

Sometimes I feel like an idiot - such a common sense solution.

Thank you

[az38]

@Anonymous 

don't say so - there are no idiotic questions. It's just a matter of practice. For me, each thread here is a lesson

good luck!

[Anonymous]

@az38 Many thanks for your kindness and nice words!