Show workername with single selection, show 'All' with multiple select

[RemiAnthonise]

With the following DAX I can show a label if one value is selected. 

Workername = "Label" & " " & 'Name'[Name]. If multiple values are selected it shows the first name. I'm trying to create a simple formula which gives me 'All' (or something like that) of no selection / multiple values are selected. 

I made a sample file here. I think it must be something like this:

IF (DISTINCTCOUNT('Name'[Name]) > 1; "All"; "Accountmanager" & " " & 'Name'[Name]) 

or 

IF (SELECTEDVALUE('Name'[Name]) > 1; "All"; "Accountmanager" & " " & 'name'[Name])

Thanks for your help.

[Anonymous · Accepted solution]

Hi,

Please try this code:

Workername = 
SWITCH(TRUE();
ISFILTERED('Name'[Name]) = FALSE() && DISTINCTCOUNT('Name'[Name]) > 1; "All";
ISFILTERED('Name'[Name]) = TRUE() && DISTINCTCOUNT('Name'[Name]) > 1; "Multiple accountmanagers selected";
"Accountmanager" & " " & VALUES('Name'[Name]))

[Anonymous · Accepted solution]

Hi,

Please try this code:

Workername = 
SWITCH(TRUE();
ISFILTERED('Name'[Name]) = FALSE() && DISTINCTCOUNT('Name'[Name]) > 1; "All";
ISFILTERED('Name'[Name]) = TRUE() && DISTINCTCOUNT('Name'[Name]) > 1; "Multiple accountmanagers selected";
"Accountmanager" & " " & VALUES('Name'[Name]))

[RemiAnthonise]

Nice one, thanks a lot!

[Anonymous · Accepted solution]

---

@RemiAnthonise wrote:

Nice one, thanks a lot!

---

Workername = 
SWITCH(TRUE();
(ISFILTERED('Name'[Name]) = FALSE() && DISTINCTCOUNT('Name'[Name]) > 1) || (ISFILTERED('Name'[Name]) = TRUE() && DISTINCTCOUNT('Name'[Name]) = CALCULATE(DISTINCTCOUNT('Name'[Name]);ALL('Name'[Name]))); "All";
ISFILTERED('Name'[Name]) = TRUE() && DISTINCTCOUNT('Name'[Name]) > 1; "Multiple accountmanagers selected";
"Accountmanager" & " " & VALUES('Name'[Name]))

I noticed that the DAX formula is actually wrong. bcus if you select all values through a slicer it would have ended up with multiple selected. I've added the bold part which solves that problem.