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