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

Another DAX syntax help

Hi all, 

I have a dax query that I want to filter the column to show all 0s and not nulls

I have  table[columnname] = 0 , Not isblank (table[columnname])

but I am not getting the result expected, any help/advice appriciated 

thanks 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Another DAX syntax help

@atrinhatra,

 

You may check code below.

Table 2 =
FILTER (
    'table',
    'table'[columnname] = 0
        && NOT ( ISBLANK ( 'table'[columnname] ) )
)
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Community Support Team
Community Support Team

Re: Another DAX syntax help

@atrinhatra,

 

You may check code below.

Table 2 =
FILTER (
    'table',
    'table'[columnname] = 0
        && NOT ( ISBLANK ( 'table'[columnname] ) )
)
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.