topic Re: Return a value if all names selected in DAX Commands and Tips

Return a value if all names selected

Anonymous — Fri, 03 Feb 2023 17:09:51 GMT

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.

Re: Return a value if all names selected

FreemanZ — Fri, 03 Feb 2023 22:58:12 GMT

hi Anonymous

try like:

Role Goal (Monthly) =

VAR _name =

MAX(TeamUsers[PersonName])

RETURN

IF(

HASONEVALUE(TeamUsers[PersonName]),

SWITCH(_name,

"name", 10000000/12,

"name", 6000000/12,

"name", 12000000/12,

"N/A"),

5000000

)

Re: Return a value if all names selected

Anonymous — Mon, 06 Feb 2023 09:05:00 GMT

Perfect, thank you FreemanZ!