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 syntaxes wrong most of the time 

 

basicly first table and column already filtered so I reuse that column first than I want to say if column two = null than TRUE if the value is blank; otherwise FALSE.

 

thanks 

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.

5 Replies

  • 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