Last answered:

11 Oct 2025

Posted on:

17 Nov 2023

1

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

19 Feb 2024

0

It is working perfectly.

Posted on:

09 Nov 2024

0
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.
Posted on:

11 Oct 2025

1

If under [SalesAmount] you mean the separate Measure SalesAmount = sum(fact_InternetSales[SalesAmount])


- yes, this DAX works too.

Submit an answer