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

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 

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.