Star scheme matrix with multiple dimensions, show blank values in matrix issue

[Robin92]

Good day,

I have been struggeling with this issue for a while and hopefully somebody can help me out.
I am using a standard star schema with Facts with a one to mane relationship to dimensions.
To explain the problem please refer to below screenshot:

If i put the customer name from the dim.customer and the contract name from dim.contract in a matrix, it perfectly shows the values.
Now comes the problem. I havent dont any sales on Contract ID 1. If i enable Show items with no value i do not get the desired results which is logic. 
There is no connection between the two dimensions because the contract id 1 is not in the fact table.
Is it possible to solve this issue and also show values with no revenue?
Or is that only possible by only using one dimension?

thank you in advance!

Gr Robin

[Robin92]

Both are working,
Thank you very much!

Gr Robin

[v-easonf-msft · Accepted solution]

Hi, @Robin92 

You can also try to replace the original field "sales" with the following measure in your table visual:

Measure =
COALESCE ( SUM ( Fact[Sales] ), 0 )

 Best Regards,
Community Support Team _ Eason

[amitchandak]

@Robin92 , You can create a measure with +0 and try 

Sum(Fact[sales])+0