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)
There are many ways to skin a cat, variables improve code readablity and in a lot of cases help avoid reptetive measures