Display 0 instead of blank in Matrix visual

[ak28121]

Hi All,
Please see below snap, I want to display zero instead of blank in matrix visual in Power BI, didn't able to achieve it by using measures too (Tried sumx as well as measure+0) 
This report is consist of multiple dimesnion and fact table and all the dimesnion is connected with fact with 1to* relationship,except one table i.e. dim table 3 (Dim table 3 is connected with dim table 5 on 1to* relationship and then dim table 5 is conencted with fact table on 1to* many relationship.(Creating snowflake schema)
Column from dim table 4 having 2 categories , and it is showing blank for one category if other category have data.
and if i go with measure creation, i think it didn't pass the filter context to all the tables, and if i try measure+0 then i an getting error of visual exceeds limit resource.

please help/suggest in this case on how to achieve this.

[ak28121]

hi @v-kongfan-msft , can you please help in this ?

[ak28121]

Hello power users, can anyone help on above issue ?

[Anonymous]

Hi @ak28121 ,

Can you provide some test data and describe it?

Best Regards,
Adamk Kong

[ak28121]

Hi @Anonymous , please find below link
https://drive.google.com/file/d/1HjdG-XEy9RagVfxCHh4LtCXTUaHrZeAG/view?usp=drive_link

[ak28121]

Hi @v-kongfan-msft , could you please help in this ?
I've placed sample PBIX file on above link