Forum Discussion

StoryofData's avatar
StoryofData
Helper III
3 years ago
Solved

SWITCH FUNCTION

I am trying to use SWITCH, it seems to be working but when the column is not summarized but when I do a count then it counts BLANKS, what am I doing wrong? 

Column 2 =
SWITCH(
TRUE (),
'Table'[EmplId] = BLANK (), BLANK(),
COMBINEVALUES("-",'Table'[EmplId],'Table'[CaseNumber]))

 

Need Help
Tutorial Requests
  • BrianConnelly's avatar
    BrianConnelly
    3 years ago

    I think the issue is after the last condition then.  Switch has a default if no conditions are true, e.g.

    SWITCH(TRUE()
,Test, Result
,Test, Result
,Default)

     

    Change your code to the following:

    SWITCH (
TRUE (),
'Table'[EmplId] = BLANK (), BLANK (),
'Table'[IssueSub Formatted] = BLANK (), BLANK (),
'Table'[City] = "Not Applicable", BLANK (),
'Table'[City] = "Not Disclosed", BLANK (),
'Table'[IssueSub Formatted] = "Referral/Redirect", BLANK (),
'Table'[Title Categorized] = "Former Employee", BLANK (),
'Table'[EmplId] <> BLANK ()
,COMBINEVALUES (" - ", [CaseNumber], [EmplId]))

     

    Let me know if that fixed it.  I removed the =TRUE()

4 Replies

  • BrianConnelly's avatar
    BrianConnelly
    Resolver III
    3 years ago

    Why a SWITCH if you only have one condition?

    IF(ISBLANK(EmpLid), BLANK(), COMBINEVALUES("-",'Table'[EmplId],'Table'[CaseNumber]))
    • StoryofData's avatar
      StoryofData
      Helper III
      3 years ago

      I have at least 5 other conditions, I just shortened it for the sake of the question, thought I'd be able to apply the solution across the entire syntax

      SWITCH (
      TRUE (),
      'Table'[EmplId] = BLANK (), BLANK (),
      'Table'[IssueSub Formatted] = BLANK (), BLANK (),
      'Table'[City] = "Not Applicable", BLANK (),
      'Table'[City] = "Not Disclosed", BLANK (),
      'Table'[IssueSub Formatted] = "Referral/Redirect", BLANK (),
      'Table'[Title Categorized] = "Former Employee", BLANK (),
      'Table'[EmplId] <> BLANK ()
      = TRUE (),
      COMBINEVALUES (" - ", [CaseNumber], [EmplId]))

      If any of these columns have values I do not want - blanks, not applicable then I want the column value for that row to be empty
      • BrianConnelly's avatar
        BrianConnelly
        Resolver III
        3 years ago

        I think the issue is after the last condition then.  Switch has a default if no conditions are true, e.g.

        SWITCH(TRUE()
,Test, Result
,Test, Result
,Default)

         

        Change your code to the following:

        SWITCH (
TRUE (),
'Table'[EmplId] = BLANK (), BLANK (),
'Table'[IssueSub Formatted] = BLANK (), BLANK (),
'Table'[City] = "Not Applicable", BLANK (),
'Table'[City] = "Not Disclosed", BLANK (),
'Table'[IssueSub Formatted] = "Referral/Redirect", BLANK (),
'Table'[Title Categorized] = "Former Employee", BLANK (),
'Table'[EmplId] <> BLANK ()
,COMBINEVALUES (" - ", [CaseNumber], [EmplId]))

         

        Let me know if that fixed it.  I removed the =TRUE()