How to make dropdown slicer present "multiple selections" if more than one value has been selected?

[ChrisFloko]

Hello everyone, 

In order to solve the problem I had in the 1st screenshot I applied the dax code  shown in the 2nd screenshot. The code seems to be working perfectly fine as long as the user has chosen one specific deparment (single selection), the output is shown in screenshot 3.  However in the case where a user picks a second deparment (screenshot 4), the measure will continue to show only one of the two or multiple selections. Is there a way to tweak the code  (or a completely different code), that could instead show "Multiple selections" (Screenshot 5) when the user has chosen more than one departments? 

1st

2nd 

3rd 

4th 

5th 

Thank you in advance!

[ChrisFloko]

@123abc Thank you so much for your reply. Truly appreciated!
I had to implement your solution within the code that I aleready had (to cater for the hierarchy) and it worked perfectly. Here is the full solution if anyone has the same challenge. 

Additional note: The output with the departments being separated by comma works perfectly fine, but when I said "Multiple selections" I literally meant if there is a way to present that exact text string if more than one departments is selected? (as shown in screenshot 5) . Basically if there is a way to modify the dax code to understand if multi-selection is present and then output a cerartin "text"  when there is. 

[123abc · Accepted solution]

It seems you want to modify your DAX code to handle multiple selections in a dropdown slicer and display "Multiple selections" when more than one department is selected. To achieve this, you can use the following DAX code:

SelectedDepartments = CONCATENATEX(ALLSELECTED('YourTable'[Department]), 'YourTable'[Department], ", ")

Replace 'YourTable' with the actual name of your table and 'Department' with the name of the column you are filtering.

This code uses the CONCATENATEX function to concatenate the selected department values into a single string separated by commas. If multiple departments are selected, it will display all the selected departments separated by commas. If only one department is selected, it will display that department's name. You can then use the "SelectedDepartments" measure in your report to display the result.

Here's how you can use this measure:

1. Create a measure in Power BI using the above DAX code.
2. Insert a text box or card visual in your report.
3. Set the visual to display the "SelectedDepartments" measure.

Now, when you select multiple departments in your dropdown slicer, the visual will display "Multiple selections," and when you select a single department, it will display the department's name.

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

In case there is still a problem, please feel free and explain your issue in detail, It will be my pleasure to assist you in any way I can.