Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
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
Hi,
Try this
ISBLANK(tablename[columnname])
and
NOT(ISBLANK(tablename[columnname]))
Hope this helps.
Maybe try something like IF(SELECTEDVALUE(tablename[columnname], 'x') = BLANK(), ....)
or
IF(ISBLANK(SELECTEDVALUE(tablename[columnname], 'x') ), ....)
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |