Resolved: Possible alternative solution to writing every single currency
The code below:
Total di SalesAmount per CurrencyKey = (
var totalForCurrency = CALCULATE(
SUM('fact_InternetSales'[SalesAmount]),
ALLSELECTED('fact_InternetSales'[CurrencyKey])
)
RETURN
IF(ISFILTERED(dim_Currency[CurrencyAlternateKey]), totalForCurrency, "No currency selected"))
is a valid option instead of writing the codes of individual currencies?
Thanks a lot
1 answers ( 1 marked as helpful)
Absolutely, there are many ways to achieve the desired result