Return a value if all names selected

[BotBot1]

Hi,

I have a DAX for the sales goals of a group of people:

Role Goal (Monthly) = 
SWITCH(TRUE(), 
MAX(TeamUsers[PersonName]) = "name", 10000000/12,
MAX(TeamUsers[PersonName]) = "name", 10000000/12,
MAX(TeamUsers[PersonName]) = "name", 6000000/12,
MAX(TeamUsers[PersonName]) = "name", 12000000/12,
MAX(TeamUsers[PersonName]) = "name", 12000000/12,
MAX(TeamUsers[PersonName]) = "name", 12000000/12,
MAX(TeamUsers[PersonName]) = "name", 12000000/12,
"N/A")

Could I have the DAX adjusted so that if all users were selected from a slicer it would return 5 million? 

Notes: 

I have actual names within "name" have just removed for confidentiality!

The monthly total goal (5 million) is not the sum of everyones goal, but this is what it needs to be.

Thank you.

[FreemanZ · Accepted solution]

hi @BotBot1 

try like:

Role Goal (Monthly) = 

VAR _name = 

MAX(TeamUsers[PersonName]) 

RETURN

IF(

    HASONEVALUE(TeamUsers[PersonName]),

    SWITCH(_name, 

    "name", 10000000/12,

    "name", 10000000/12,

    "name", 6000000/12,

    "name", 12000000/12,

    "name", 12000000/12,

     "name", 12000000/12,

     "name", 12000000/12,

      "N/A"),

      5000000

)

[BotBot1]

Perfect, thank you @FreemanZ!