Dividing by Set Analysis is Filtering Data

[Brysonds]

Hello,

I have a simple table of currencies and rates.

I want to divide all rates by a single rate.

I tried this expression: Sum([Month End Rate]) / Sum({<Currency={EUR}>}[Month End Rate])

However, when I look at the table of currency, month end rate, and this measure, it only shows me the calculation for EUR.

I want to see all currencies, their month end rate, and a 3rd column which is month end rate / EUR rate.

Currency	Month End Rate	Value I want (rate / eur rate)	Value I am getting using measure above
AED	3.67	4.12	-
DKK	6.67	7.49	-
EUR	0.89	1.00	1
GBP	0.74	0.83	-

[chrismarlow · Accepted solution]

Hi,

Not tested but maybe try;

Sum([Month End Rate]) / Sum(TOTAL {<Currency={EUR}>}[Month End Rate])

Cheers,

Chris.

[Brysonds]

That was the trick!! Thank you so much for the quick reply and guidance!