POWER BI matrix not showing 0

[rachel_loh21]

I use column total to calculate percentage in values, but it shows blank instead of 0% for those without value. Please help!

[Anonymous · Accepted solution]

Thanks for the reply from PijushRoy , please allow me to provide another insight:

Hi  @rachel_loh21 ,

I created some data:

Here are the steps you can follow：

1. Create measure.

Test =
var _column=SUMX(FILTER(ALL('Table'),'Table'[Month]=MAX('Table'[Month])),[Value])
return
DIVIDE(SUM('Table'[Value]),_column)+0

2. 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

[PijushRoy]

Hi @rachel_loh21 

To solve this problem, please create and use one measure in place of column

% Measure =
IF ( Table[%CT SMT percentage] = BLANK (), 0, Table[%CT SMT percentage] )

or

% Measure =
IF ( HASONEVALUE ( Table[%CT SMT percentage] ), Table[%CT SMT percentage], 0 )