Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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 

 

Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    7 years ago

    Anonymous,

     

    You may check code below.

    Table 2 =
FILTER (
    'table',
    'table'[columnname] = 0
        && NOT ( ISBLANK ( 'table'[columnname] ) )
)

1 Reply

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support
    7 years ago

    Anonymous,

     

    You may check code below.

    Table 2 =
FILTER (
    'table',
    'table'[columnname] = 0
        && NOT ( ISBLANK ( 'table'[columnname] ) )
)