Currency conversion with symbol based on slicer

[SAPpowerbi]

Hello Team,

I need Dynamic Value( Total sales )with Currency symbol based on slicer selection ,

for that i am using below Table 

Source -

i am creating table with below two column .

Table Name - Currency Table 

Currency name	Rate
USD	1.2
YEN	1.4

Output -

I am using currency name as slicer (Filter) .

-USD

-GBP

based on above slicer when i select USD i want value(Total sales ) as USD -$100 and when we select YEN then -¥100

for that i am using below formula , this working for me but formula convert to text , i need formula as number not text .

Forumula - 1 

Selected Currency = VALUES('Currency Table'[Currency Name])

Formula 2-

Total sales = SWITCH(TRUE(),
[Selected Currency ]="USD",FORMAT([Total sales]*VALUES('Currency Table'[Rate]),"$0,00"),
[Selected Currency ]="YEN",FORMAT([Total sales]*VALUES('Currency Table'[Rate]),"¥0,00"),

[Total sales]))

when i create above dax values convert in to text , i want that become a Number .please help me to write dax.

Thank you in advance.

[parry2k · Accepted solution]

@SAPpowerbi you can easily achieve this by using Calculation Group and here is a great article on this.

✨ Follow us on LinkedIn

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[Greg_Deckler]

@SAPpowerbi Yeah, not sure if there is a way to do that. Currency is based on local system settings so not even Custom Format Strings will help.