Last answered:

20 Apr 2022

Posted on:

19 Apr 2022

3

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)
Instructor
Posted on:

20 Apr 2022

0

Absolutely, there are many ways to achieve the desired result

Submit an answer