Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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') ), ....)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |