cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
atrinhatra Member
Member

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 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
AkhilAshok Established Member
Established Member

Re: Another DAX syntax help required

Maybe try something like IF(SELECTEDVALUE(tablename[columnname], 'x') = BLANK(), ....)

or

IF(ISBLANK(SELECTEDVALUE(tablename[columnname], 'x') ), ....)

Super User
Super User

Re: Another DAX syntax help required

Hi,

 

Try this

 

ISBLANK(tablename[columnname])

 

and

 

NOT(ISBLANK(tablename[columnname]))

 

Hope this helps.

5 REPLIES 5
atrinhatra Member
Member

Re: Another DAX syntax help required

any dax expert out  there can help?

Super User
Super User

Re: Another DAX syntax help required

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.

atrinhatra Member
Member

Re: Another DAX syntax help required

@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 

Highlighted
AkhilAshok Established Member
Established Member

Re: Another DAX syntax help required

Maybe try something like IF(SELECTEDVALUE(tablename[columnname], 'x') = BLANK(), ....)

or

IF(ISBLANK(SELECTEDVALUE(tablename[columnname], 'x') ), ....)

Super User
Super User

Re: Another DAX syntax help required

Hi,

 

Try this

 

ISBLANK(tablename[columnname])

 

and

 

NOT(ISBLANK(tablename[columnname]))

 

Hope this helps.

Helpful resources

Announcements
Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 6 members 3,166 guests
Please welcome our newest community members: