In the first part of the video ...
In the first part of the video, is there a difference between what you wrote and that ? : titleBar = IF(ISFILTERED(dim_Currency[CurrencyAlternateKey]), "Sales Amount In " & VALUES(dim_Currency[CurrencyAlternateKey]) & " Vs All Currencies" , BLANK ())
....................................................................
And what is the difference between this and that, please?!
6 answers ( 0 marked as helpful)
the difference between what exactly are you asking? I can see the DAX for the title bar which is essentially creating a string with the selected currency if a currency code has been selected otherwise it will show blank.
Do you mean that there is no difference or something else please!
I still don't understand what difference do you mean? You have provided me with one piece of DAX code, the difference between this DAX code and what else?
is it correcte to write the dax expression in that way :
Title = if(ISFILTERED(dim_Currency[CurrencyName]),
"Sales Amount in "&SELECTEDVALUE(dim_Currency[CurrencyName])&" vs All Currency", "Please Select a Currency from the Dropdown Menu ").
Thanks in advance
Title = if(ISFILTERED(dim_Currency[CurrencyName]),
"Sales Amount in "&SELECTEDVALUE(dim_Currency[CurrencyName])&" vs All Currency", "Please Select a Currency from the Dropdown Menu ").
Thanks in advance
I have not run the code myself, but looks ok
thanks