Calculated new rows with filter

[Gerald23]

Hi all,

I have a table that looks like this:

The problem is that the Online Price for country UK is in Pounds and the Online Price for other countries is in Euro.

I would like to add a row to the table when country is UK that calculates the price in EURO that gets a different country name : UK in Eur. I already have the exchange rate loaded in a measure called "EUR per unit for GBP"

So it would look something like this:

That way i could show it in a matrix view on different columns.

Is this possible and if so how could i achieve this?

[amitchandak · Accepted solution]

@Gerald23 , My suggestion would be to add a new column not a row

refer if needed

https://www.sqlbi.com/articles/currency-conversion-in-power-bi-reports/

https://radacad.com/currency-exchange-rate-conversion-in-power-bi-with-live-rates-part-2

[Gerald23]

Thanks this helped me to make it work for now 🙂 I added a column currency based on country and setup the relationship with the exchange rate table. Then I was able to multiply the online price by the exchange rate now it also shows the UK prices in Euro which is good enough for now.