SalesAmountSelectedCurrency DAX
Is it ok to use below DAX;
SalesAmountSelectedCurrency = IF(ISFILTERED(dim_Currency[CurrencyAlternateKey]),[SalesAmount],"No currency selected")
3 answers ( 0 marked as helpful)
It is working perfectly.
I also used isfiltered and I think it's much easier then using variables.It gives the same results, I don't know if it's correcte or not.
If under [SalesAmount] you mean the separate Measure SalesAmount = sum(fact_InternetSales[SalesAmount])
- yes, this DAX works too.