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

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

Follow this topic

Last answered:

19 Mar 2023

Posted on:

19 Mar 2023

Resolved: The benefits of variables

1 answers ( 1 marked as helpful)

Dimitar Shutev

Instructor

Posted on:

19 Mar 2023

Helpful answer