Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

check vaules

Hi Everyone, I need Help,   I want to Create Calculate colmun in table 1 with name message  to show Text Message after check value in others table, based on below tables  table 1 id messag...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Why is 5 in table 4, but not table 3? Is there any priority? You may try something like this, I think.. 

    = SWITCH( TRUE(), 
              COUNTROWS( FILTER( Table2, 
                                 Table2[id] = Table1[id])) > 0, "in table2", 
              COUNTROWS( FILTER( Table3, 
                                 Table3[id] = Table1[id])) > 0, "in table3", 
              ... 
              BLANK())
Anonymous's avatar
Anonymous
Not applicable
7 years ago

thanks Anonymous  for  your replay,

 

but when I write equality

Table2[id] = Table1[id]

 the Table1[id] sentence show error or not defined, can you tell me about how  the  relation must be done between table1, table2, table3 and table 4

Anonymous's avatar
Anonymous
Not applicable
7 years ago

hi ,

There is no need to add relationships. Please check the names as AIB suggested.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    thanks Anonymous , AlB 

    I Not use names that mention it   here, I use the table  just to explain the case
    you can see below image to more details, maybe after = sign must be an expression or a column name.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Anonymous , AlB 

      IT'S  WORK WITH ME, BUT I WANT TO STORE ONE VALUE  IF THE CONDITION IS  TRUE
      PLEASE CHECK  BELOW  DAX FORMAL

      -----

      Message =

       

      SWITCH( TRUE(),
      COUNTROWS( FILTER( 'test Staff',
      'test Staff'[IDENTIFICATIONNUMBER] = ReasonsNotReg[id])) > 0, " Staff",

      COUNTROWS( FILTER( ReasonsNotReg,
      ReasonsNotReg[line] = BLANK()


      )) > 0, "Havn't Line",
      COUNTROWS(FILTER( ReasonsNotReg,
      ReasonsNotReg[number] = "x-0002987" || ReasonsNotReg[number] = "x-0032987"

      || ReasonsNotReg[number] = "x-030502987"

      || ReasonsNotReg[number] = "x-00022987"

      || ReasonsNotReg[number] = "x-04002987"



      ) ) > 0, "Worker",


      COUNTROWS( FILTER( ReasonsNotReg,
      ReasonsNotReg[main st] = BLANK()

      )) > 0, "Not Have STATUSE",


      COUNTROWS( FILTER( ReasonsNotReg,
      ReasonsNotReg[start] = BLANK()

      )) > 0, "not start",



      BLANK())

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago
        If you didn't get what you want, please let us know your expected result.