Forum Discussion
black value replace in zero in matrix
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
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]) +04. 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
1 Reply
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]) +04. 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