Dynamic title using 2 different columns

[nok]

Hi!

I'm trying to do something I thought would be simple, but I'm having trouble getting it right. I want to create a title at the top of my dashboard page that has the fixed text "SALES DASHBOARD" concatenated with the [Year] and [Area] values ​​the user selected in the Year and Area filters on my dashboard. It would be something like this: "SALES DASHBOARD " && MyTable[Year] && MyTable[Area]".

I tried creating this metric like this, but I get an error message.

_measure = 
"SALES DASHBOARD " && 
   IF(
    HASONEFILTER(MyTable[Year]), 
         VALUES(MyTable[Year]), 
    IF(
    HASONEFILTER(MyTable[Area]), 
         VALUES(MyTable[Area]), 
    ""
))

How can I do this?

[NimaiAhluwalia · Accepted solution]

Hello @nok 

The issue is that VALUES() returns a table, not a scalar value, which causes the error when used inside a string concatenation. To fix this, you’ll want to use CONCATENATEX() to convert selected values into a string.

DashboardTitle =
"SALES DASHBOARD " &
IF (
    ISFILTERED ( MyTable[Year] ),
    " - " & CONCATENATEX ( VALUES ( MyTable[Year] ), MyTable[Year], ", " ),
    ""
) &
IF (
    ISFILTERED ( MyTable[Area] ),
    " - " & CONCATENATEX ( VALUES ( MyTable[Area] ), MyTable[Area], ", " ),
    ""
)