topic Re: Calculated Column with COUNTROWS, Wildcard and in Multi Level Relationship in DAX Commands and Tips

Calculated Column with COUNTROWS, Wildcard and in Multi Level Relationship

joshua1990 — Sat, 04 Feb 2023 11:44:23 GMT

Hello community!

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

Table 1

Table 2

Table 3

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_"

How would you do that?

tamerj1 — Sat, 04 Feb 2023 12:55:04 GMT

are the tables connected?

joshua1990 — Sat, 04 Feb 2023 13:28:29 GMT

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

tamerj1 — Sat, 04 Feb 2023 13:52:17 GMT

please try

COUNTROWS (

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