Something going wrong in power pivot

[sharshra]

I have to get values from 2 tables. I´m using power pivot to manipulate data in these 2 tables. But I´m making some mistake & not getting the right values. Can the experts point out what is wrong & advise how to fix?

Consider the following tables.

Table - detRq

excel problems.xlsx
	B	C	D	E
2	#	Mod	Desc	TC
3	1	C	dfd	2
4	2	L	dvsv	no
5	3	A	erer	no
6	4	L	hgh	1
7	5	L	uiyui	9
8	6	L	czc	no
9	7	C	cvnv	21
10	8	C	4rf	36
11	9	C	34ref	no
12	10	L	erer	3
Sheet2

Table - detTC

excel problems.xlsx
	G	H	I
2	#	Mod	TCD
3	1	C	fd
4	2	C	re
5	3	L	jk
6	4	L	bnm
7	5	L	hkhhff
8	6	L	2vcv
9	7	C	7,n,hj
10	8
11	9
12	10
13	11
14	12
15	13
16	14
17	15
Sheet2

I´m using power pivot to combine these 2 tables. Also, created a measure `no TC´ to count `no´ in table detRq.

After this, I have created a pivot. In this pivot, I have the following -
Table detRq - Mod, count of Mod & no TC
Table detTC - Mod

I want to get the number of Mod & count of `no TC´ for each Mod. This is working correctly. Next, I want to count the Mod from detTC. This is not working correctly. As seen in the table below, I´m getting the total count against all Mod in column Mod-TCD. Expected values are shown in the next column in green cells. How can I get the correct values in the final pivot table under the column Mod-TCD?

Final pivot -

excel problems.xlsx
	K	L	M	N	O
3	Mod	Mod count	no TC	Mod-TCD
4	A	1	1	7	0
5	C	4	1	7	3
6	L	5	2	7	4
7	Total	10	4	7
Sheet2

Cell Formulas
Range	Formula
O4:O6	O4	=COUNTIF(detTC[Mod],K4)