Numeric column showing 1 when database value is blank or 0

[Anonymous]

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 ?

[v-eachen-msft]

Hi @Anonymous ,

It seems that you have solved the problem, then you could accept your reply.

[Anonymous]

I mean the column is showing as "count of columnname", though its not summerized in power bi

[Anonymous · Accepted solution]

Resolved, I chose don't summarize at the table level on the LHS