Last answered:

19 Mar 2023

Posted on:

19 Mar 2023

0

Resolved: The benefits of variables

Why did you use a variable in the title measure where you could have used an IF statement ? 
This is what I did and it works perfectly: 
Title = IF(ISFILTERED(dim_Currency[CurrencyAlternateKey]), "Sales Amount in "& VALUES(dim_Currency[CurrencyName])&" vs All Currencies","Please Select Currency from the Dropdown Menu")
PS: I know that I used the currency name in my title bar, I just prefer it that way :p  

1 answers ( 1 marked as helpful)
Instructor
Posted on:

19 Mar 2023

1

There are many ways to skin a cat, variables improve code readablity and in a lot of cases help avoid reptetive measures

Submit an answer