Posted on:

14 Nov 2024

0

SalesAmountSelectedCurrency

This dax will be more useful if there are more values(all currencies across the globe) in a CurrencyAlternateKey.


SalesAmountSelectedCurrency = 
VAR SelectedCurrency = SELECTEDVALUE(dim_Currency[CurrencyAlternateKey])
RETURN
IF(
    NOT ISBLANK(SelectedCurrency),
    CALCULATE(
        SUM(fact_InternetSales[SalesAmount]),
        dim_Currency[CurrencyAlternateKey] = SelectedCurrency
    ),
    "No Currency Selected"
)

0 answers ( 0 marked as helpful)

Submit an answer