Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Multi conditional switch statement

Hello  -  I have a situaiton where I have a Switch statment that only partially works.    I am curious if there is a better way to write this (that actually works!) or perhaps use  VAR.      My use...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    One more ) right before your RETURN statement

     

    Multiple or Single = 
  VAR __Table = 
    DISTINCT(
      SELECTCOLUMNS(
        FILTER(
          ALL('Table'),
          [RMA] = EARLIER([RMA])
        ),
        "__Problem Code",[Problem Code]
      )
    )
RETURN
  IF(COUNTROWS(__Table) > 1,"Multiple","Single")
Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

So, no sample text data provided and I don't like typing so going to wing this DAX calculation, apologies in advance for syntax errors. This is for a column.

 

Multiple or Single = 
  VAR __Table = 
    DISTINCT(
      SELECTCOLUMNS(
        FILTER(
          ALL('Table'),
          [RMA] = EARLIER([RMA])
        ),
        "__Problem Code",[Problem Code]
    )
RETURN
  IF(COUNTROWS(__Table) > 1,"Multiple","Single")

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks Greg.   I do get two errors.     When I hover over the __Table it says  "Parameter is not the correct type.   Cannot find name __Table.

     

    And it says the syntax for Return is incorrect.   

     

    Any idea why this is happening?  

     

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      6 years ago

      In your VAR statement, replace the comma at the end with a )

       

      I believe that should fix it. 

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Thanks Greg  -  Sorry to trouble you but I still got an error.     The red lines are saying 1) a syntax error with Return, and 2) the other two red lines say these are "Unexpected Expressions". 

         

        So close....!