Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Column not appearing in SWITCH function

Hi there,

 

I am having some issues with SWITCH funtion.

I am trying to categorise NPS by score using SWITCH function -

NPS Category =
SWITCH(
TRUE(),
'Data'[NPS] >= 9, "Promoter",
'Data'[NPS] >= 7 && 'Data'[NPS] < 9, "Passive",
"Detractor"
)

But when looking for columns in 'Data' all it sees are measures.

 

Thank you for your help!

Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    2 years ago

    Hi Anonymous 

     

    Download PBIX file with example below

     

    The DAX needs you to give it a single value for NPS - it shoudl have been giving you that error message?

     

    Try this, works for me

     

     

    NPS Category = 

VAR _nps = SELECTEDVALUE('Data'[NPS])

RETURN

SWITCH(
TRUE(),
 _nps >= 9, "Promoter",
_nps >= 7 && _nps < 9, "Passive",
"Detractor"
)

     

     

     

    Regards

     

    Phil

     

1 Reply

  • PhilipTreacy's avatar
    PhilipTreacy
    Super User
    2 years ago

    Hi Anonymous 

     

    Download PBIX file with example below

     

    The DAX needs you to give it a single value for NPS - it shoudl have been giving you that error message?

     

    Try this, works for me

     

     

    NPS Category = 

VAR _nps = SELECTEDVALUE('Data'[NPS])

RETURN

SWITCH(
TRUE(),
 _nps >= 9, "Promoter",
_nps >= 7 && _nps < 9, "Passive",
"Detractor"
)

     

     

     

    Regards

     

    Phil