Help with CONCATENEX

[Fusilier]

Hi,

I have this measure using CONCATENEX:

Measure 2 = CONCATENATEX ( VALUES ('Raw Data'[Department]) , [Department] , ", ")

It works fine with a dynamic text box showing multiple selections from a slicer (Department A, Department B etc.). However when nothing has been selected on the filter it displays a list of all of the slicer values.

Is there any way of modifying the measure so if nothing has been selected there is a message such as 'Nothing selected' or 'Choose Departments'?

[dharmendars007 · Accepted solution]

Hello @Fusilier 

Please try the below measure..

Measure 2 =
IF(
ISFILTERED('Raw Data'[Department]),
CONCATENATEX(VALUES('Raw Data'[Department]), [Department], ", "),
"Choose Departments")

If you find this helpful , please mark it as solution and Your Kudos are much appreciated!

Thank You

Dharmendar S

LinkedIN 

[Fusilier]

Blimey, that was quick!

Works like a dream.

Thank you.