Matrix not showing data for all rows It is showing data only for those rows that has non zero value

[NG1407]

I am creating a report where I am showing total numbers,percentage and average score. But It is showing values only for those questions that has non zero value.

I created below measure to calculate total numbers 

CALCULATE(DISTINCTCOUNT(Table1[QKey],USERRELATIONSHIP(Table2[QID],Table1[QID]))

I want to show data as below:

Section	Question	Answer	Total Number
Section1	1.1 Ask questions	yes	32
		no	0
	1.2 Leverage resource	Full	25
		No	7
		Partial	0

But It is showing like this

Section	Question	Answer	Total Number
Section1	1.1 Ask questions	yes	32
	1.2 Leverage resource	Full	25
		No	7

[NG1407]

Can anyone help with solution. Or help in below ques

I have 2 tables. And they are having many to many relationship using QQkey. I want to create one conditional column in Tables 1

If Table1.qekey = Table2.qekey then Table1.qformid else 0

[miTutorials]

Right click on the Question field and select 'Show items with no data'

If that does not work then use an if statement to return 0.

Measure = IF(ISBLANK(CALCULATE(DISTINCTCOUNT(Table1[QKey],USERRELATIONSHIP(Table2[QID],Table1[QID])))),0,1)

Regards

Ismail

[NG1407]

Thanks Ismail. But it didn't solve my problem. When I tried this it started showing all the Questions and Anwers available in table. As shown below in question column 1.1 Accept and 1.1 Insert got added and in Answer column these got added 

billing,Neutral,Name,Other 1,Other 2,Payment option

Section	Question	Answer	Total Number
Section1	1.1 Ask questions	yes	32
		no	0
		Neutral	0
		Name	0
	1.1 Accept	Yes	0
		No	0
	1.1 Insert	Yes	0
		No	0
	1.2 Leverage resource	Full	25
		No	7
		Partial	0
		Other 1	0
		Other 2	0
		payment option	0
		billing	0