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...
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

     

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