Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Another DAX syntax help required

Hi,  If I want to create a measure like  Measure= TablenameA[columnname], tablenameB[Columnname] = null, ISBLANK (TablenameA[columnname])   what would be the correct syntax, I seem to get syntaxe...
Need Help
  • AkhilAshok's avatar
    AkhilAshok
    7 years ago

    Maybe try something like IF(SELECTEDVALUE(tablename[columnname], 'x') = BLANK(), ....)

    or

    IF(ISBLANK(SELECTEDVALUE(tablename[columnname], 'x') ), ....)

  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

     

    Try this

     

    ISBLANK(tablename[columnname])

     

    and

     

    NOT(ISBLANK(tablename[columnname]))

     

    Hope this helps.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

any dax expert out  there can help?

Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

Hi,

 

Without seeing the data and the relationships, it is very difficult to offer a solution.  Please share a dataset, describe the question and show the expected result.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Ashish_Mathur ok let me change my question

    how do I say tablename[columnname] is euqual null

    and 

     tablename[columnname] is euqual is not null

     

    thanks 

    • AkhilAshok's avatar
      AkhilAshok
      Solution Sage
      7 years ago

      Maybe try something like IF(SELECTEDVALUE(tablename[columnname], 'x') = BLANK(), ....)

      or

      IF(ISBLANK(SELECTEDVALUE(tablename[columnname], 'x') ), ....)

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      7 years ago

      Hi,

       

      Try this

       

      ISBLANK(tablename[columnname])

       

      and

       

      NOT(ISBLANK(tablename[columnname]))

       

      Hope this helps.