Forum Discussion
Solved
Help with CONCATENEX
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'?
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
2 Replies
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
Blimey, that was quick!
Works like a dream.
Thank you.
