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)