Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I have a data table showing prices of different items in the local currency of each country, the date, the country, and the exchange rate of the local currency to US dollars, amount sold.
What I need is to have a report in which selecting, local currency or US dollars; The report presents me with the data in dollars or in the local currency.
The most obvious and easy thing is to have a column with the price in dollars (additional to the one in local currency), but that would lead me to have reports in both dollars and local currency; And that's tedious.
I hope you can help me.
Solved! Go to Solution.
Hi @Syndicate_Admin ,
You can try this method:
Sample data:
Then you need to new a table to be a slicer:
Then in the DataTable, new a measure:
USDORLOCAL =
var _USD = SUMX(SUMMARIZE('DataTable', 'DataTable'[Country],'DataTable'[Exchange Rate],'DataTable'[Price],'DataTable'[Items], "USD", 'DataTable'[Exchange Rate] * 'DataTable'[Price]),[USD])
var _Local = SUMX(SUMMARIZE('DataTable','DataTable'[Country],'DataTable'[Items],'DataTable'[Price]), 'DataTable'[Price])
return
IF(SELECTEDVALUE(SlicerTable[Slicer]) = "USD", _USD, _Local)
The result is:
Is this what you expect?
Hope this helps you.
Here is my PBIX file.
Best Regards,
Community Support Team _Yinliw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Syndicate_Admin ,
You can try this method:
Sample data:
Then you need to new a table to be a slicer:
Then in the DataTable, new a measure:
USDORLOCAL =
var _USD = SUMX(SUMMARIZE('DataTable', 'DataTable'[Country],'DataTable'[Exchange Rate],'DataTable'[Price],'DataTable'[Items], "USD", 'DataTable'[Exchange Rate] * 'DataTable'[Price]),[USD])
var _Local = SUMX(SUMMARIZE('DataTable','DataTable'[Country],'DataTable'[Items],'DataTable'[Price]), 'DataTable'[Price])
return
IF(SELECTEDVALUE(SlicerTable[Slicer]) = "USD", _USD, _Local)
The result is:
Is this what you expect?
Hope this helps you.
Here is my PBIX file.
Best Regards,
Community Support Team _Yinliw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
144 | |
73 | |
64 | |
52 | |
51 |
User | Count |
---|---|
208 | |
91 | |
62 | |
59 | |
56 |