How to concatenate row value and text using DAX (live connection)

[renoyzac]

Hello,

I'm just starting out with Power BI. I'm trying to concatenate the row value and text using DAX (mine is a live connection). But i'm unable to get the dimension value in the measure i'm creating.

Is this possible to do? Here the 'Dimension-Hierarchy'[Platform L3 Desc] gives an error "Cannot find name [Platform L3 Desc]"

_msr_Filtered URL = IF(
                        HASONEVALUE('Dimension -Hierarchy'[Platform L3 Desc]),
                            CONCATENATE("link", 
                            CONCATENATE("?filter=xyz'", 
                            CONCATENATE('Dimension - Hierarchy'[Platform L3 Desc],
							CONCATENATE([_msr_Selected App], 
                            CONCATENATE("'", 
                            CONCATENATE(" and filter= '", 
                            CONCATENATE([_msr_Selected L3], "'")))))), 
                            CONCATENATE("link", 
                            CONCATENATE("?filter=xyz'", 
                            CONCATENATE([_msr_Selected App], 
                            CONCATENATE("'", ""))))))

[v-xiaotang · Accepted solution]

Hi @renoyzac 

try min(), max() or selectedvalue() to get row value, e.g.

HASONEVALUE(min('Dimension -Hierarchy'[Platform L3 Desc]))

then, you also could use & to concatenate the row value and text, e.g.

I also find a tutorial, you could refer to it,

https://docs.microsoft.com/en-us/dax/text-functions-dax

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[renoyzac]

Yes, i did end up using SELECTEDVALUE(). Couldn't find any other way. 

[smpa01]

@renoyzac  can you change this to following and see if it works

CONCATENATE(MAX('Dimension - Hierarchy'[Platform L3 Desc]))
or
//if the above does not work
CONCATENATE(CALCULATE(MAX('Dimension - Hierarchy'[Platform L3 Desc]))