black value replace in zero in matrix

[Shanvitha_V]

Hi export,

I am using Matrix in Power BI but the values is count of my column
I have try Measure=count(columname)+0
or
if(ISBLANK(count(columnname)),0,count(columnname))

but no luck in matrix anybody can help me how to fix the issue now.

Thanks

Shanvitha

[v-yangliu-msft · Accepted solution]

Hi  @Shanvitha_V ,

I created some data:

Here are the steps you can follow：、

1. Create a new Table.

Table 2 =
DISTINCT('Table'[Group])

2. Related both tables.

3. Create measure.

Measure =
SUM('Table'[Value]) +0

4. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly