Numeric column showing 1 when database value is blank or 0

I  have a strange problem

My source --> Oracle view, where one of the numeric columns is displayed, and is also part of group by clause

what is happening in powerbi --> when I choose this column in the table visualization, i see the value of this column as 1 , as looks like powerbi is taking in the count of the column, instead of the value itself...and then it shows a total count at the bottom

question --> how to get rid of this behaviour, and show blank when null in oracle, and show 0 when its 0 ?