Hi, I have a dataset containing the below columns:
1. Region - with just "UK" and "USA" values
2. Category - stuff like "sales", "direct expences" etc.
3. Value - without currency symbol but it's in dollars for USA region and in pounds for UK region
4. All to £ - converts all USA values to pounds
5. All to $ - converts all UK values to dollars.
In the report, I have a slicer with "UK", "USA" and "BOTH". Another one is showing currency selector. Both slicers are based on separate datasets and are connected to the source datasets with the values in cardinality one-to-many.
I wrote a simple metric that summarises data for both countries and lets you convert those values from one currency to another.
I need an addition to my metric that will summarise values for both regions but will exclude some categories. At the same time it will still let you convert currencies.
I'm sending you what I've got:
Cur NOM Actual =
var Currency1 = SELECTEDVALUE('Currency'[Currency])
var USD = sum('Nominal Ledger Transactions Li'[Values in $])
var GBP = sum('Nominal Ledger Transactions Li'[Values in £])
return
If(Currency1 = "GBP", GBP, USD)
Tried to use the "switch" function instead but failed... It's not showing any value when I use it...
An additional feature would include adding currency symbols to the values.
May I ask for suggestions on how to do it?
