Calculated Column with COUNTROWS, Wildcard and in Multi Level Relationship

[joshua1990]

Hello community!

I have 3 table that are related to each other, always 1:n. The structure is like:

Table 1

Order Nr (Key)	Text	Text
1
2
3

Table 2

Order Nr (Key)	Order Nr Level 2 (Key)	Text
1	123	dfg
1	1273	asd
2	2352	dsf

Table 3 

Order Nr Level 2 (Key)	Text 1	Text 2
123	OK_	1
123	NOK_	1
1273	OK_	1

Now I would like to add a calulcated column into talble 1 that counts how many rows are in Table 3, for the individual Order with the string "OK_"

Order Nr (Key)	Text	Text	Result Column
1			2
2			0
3			0

How would you do that?

[tamerj1]

Hi @joshua1990 

please try

COUNTROWS (

FILTER ( CALCULATETABLE ( Table3 ), Table3[Text1] = "OK_" ) )

[tamerj1]

Hi @joshua1990 

are the tables connected?

[joshua1990]

@tamerj1 : Yes, the tables are connected via the keys that are highlighted in the column header above