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') ), ....)

View solution in original post

Super User
Super User

Re: Another DAX syntax help required

Hi,

 

Try this

 

ISBLANK(tablename[columnname])

 

and

 

NOT(ISBLANK(tablename[columnname]))

 

Hope this helps.

View solution in original post

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') ), ....)

View solution in original post

Super User
Super User

Re: Another DAX syntax help required

Hi,

 

Try this

 

ISBLANK(tablename[columnname])

 

and

 

NOT(ISBLANK(tablename[columnname]))

 

Hope this helps.

View solution in original post

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 357 members 3,822 guests
Please welcome our newest community members: