Use CONCATENATEX twice for two slicers in dynamic title

[Anonymous]

Hi there,

I'm a bit stuck with some syntax. I have two slicers for a matrix and I want to include a dynamic title that covers both slicers. 

I have the measure working for a single slicer, when I try to add the second, it breaks. 

This is what I have, can you please let me know where I've gone wrong?

Tracker Title = "CASE TRACKER FOR "& UPPER(CONCATENATEX(VALUES('Tracking'[Business Type]),'Tracking'[Business Type]," | ")) && "AND" & UPPER(CONCATENATEX(VALUES('Tracking'[Quote Status]),'Tracking'[Quote Status]," | "))

[amitchandak]

@Anonymous , Try like

Tracker Title = "CASE TRACKER FOR "& UPPER(CONCATENATEX(allselected('Tracking'[Business Type]),'Tracking'[Business Type]," | ")) && "AND" & UPPER(CONCATENATEX(allselected('Tracking'[Quote Status]),'Tracking'[Quote Status]," | "))

what is the error you are getting

[Anonymous · Accepted solution]

Hi @amitchandak 

ALLSELECTED is not working either. The error is that it cannot convert type Text to type True/False. 

I just tried removing the double ampersand from between the two arguments, and it's working now!