Multiple Currencies

[SRobbo1990]

Hi All,

I am currently building a report for multiple offices (UK and US). Obviously the US Office would like to see all their figures in Dollars. I am using a Cube so the data model is set before I even open PowerBi. 
My question is I have the 'Sum of Booking GBS BCY' which equates to local currency figures and the 'Sum of Booking GBS GBP' needed for the Global Corporate figures both in my data model, I'm wondering would it be possible to filter the report so when I filter by US it only shows 'Sum of Booking GBS BCY' and 'GBP' when filtering by UK?

Thanks

[amitchandak · Accepted solution]

@SRobbo1990 , if based on userprincipalname if you can get country then you can switch the measure 

example

Meausure =

var _cnt = maxx(filter(Table, Table[email] =userprincipalname (), ), Table[Country])

return

Switch(_cnt ,

"USA", [USD Measure],

[GBP Measure]

)