Forum Discussion
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...
Maybe try something like IF(SELECTEDVALUE(tablename[columnname], 'x') = BLANK(), ....)
or
IF(ISBLANK(SELECTEDVALUE(tablename[columnname], 'x') ), ....)
Hi,
Try this
ISBLANK(tablename[columnname])
and
NOT(ISBLANK(tablename[columnname]))
Hope this helps.
any dax expert out there can help?
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.
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
Maybe try something like IF(SELECTEDVALUE(tablename[columnname], 'x') = BLANK(), ....)
or
IF(ISBLANK(SELECTEDVALUE(tablename[columnname], 'x') ), ....)