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, ...
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] ) )
)
v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
7 years ago

Anonymous,

 

You may check code below.

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