Country currency code at the end of Sales Revenue number(e.g, $500 USD)

[Krish89]

Hello Power BI community,

I have a table in Power BI desktop as below.

I created Total Sales measure on top of the above table data.

Total Sales = SUM(Sales[Revenue])

Now I visualise this data in Matrix visual as below.

But I would like to see the data like below.

When I select Germany in the slicer, It should display the total sales by product for Germany and at the end of the sales value i need country currency code.

The currency code is available in the Sales table(above).

Also If possible I would like to display the currency symbol at front as below.

Thanks in Advance!!

[Icey · Accepted solution]

Hi @Krish89 ,

Try to create a table with all currency symbols and then create relationship between your fact table and this currency symbol table based on [Currency] column. And then, create a measure like so:

Total Sales = MAX('Currency Symbol'[Currency Symbol]) & SUM(Sales[Revenue]) & MAX(Sales[Currency])

In addition, this will transfer the result from "Number" to "Text" format.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi,

Please try this

New_Column = CALCULATE(CONCATENATE(FORMAT(SUM('Table'[REvenue]),""),min('Table'[Currency])))

Thanks!