Super learner
This user is a Super Learner. To become a Super Learner, you need to reach Level 8.
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