Replacing blank with average value in matrix visuals.

[Izzy]

Hi guys,

I am new in Power BI and trying to find a way to replace blank cells with average value in matrix visuals. 

Then I can calculate the total prices and compare differents products.

Here is a sample: 

Appreciate every suggestions for me.

Regards,

Izzy

[v-eachen-msft]

Hi @Izzy ,

Here is my test file, you can download and refer to it.

[Izzy]

HI @v-eachen-msft ,

Any other Suggestions?

Regards,

Izzy

[Izzy]

Hi @v-eachen-msft,

It looks close, but the last total is still a little questionable. The last row's sum is incorrect(40 + 30 + 20 + 78 + 52 != 245). I am blocked there. Any suggestions?   

[Izzy]

It seems like very similar to this questions.

https://community.powerbi.com/t5/Desktop/Replacing-blank-cells-in-Matrix-visuals/m-p/612814#M292062