Count rows with no rows in a related table

[Ncio]

Hello,

I have 2 related table, and I'd like to calculate the number of rows in table without any values in table 2.

==> For the example below, the result should be 2 (rows 3 and 4 are not in table 2). 

Table 1

1

2

3

4

Table 2

1

1

2

2

2

Everything I tried didn't give me the expected result, could  you help me?

Thank you!

[SpartaBI · Accepted solution]

@Ncio in case I understand your model is like this:

Then, you can create this measure:

Measure = 
COUNTROWS( 
    FILTER(
        Table1,
        ISEMPTY(RELATEDTABLE(Table2))
    )
)

In case it solved your question please mark this as a solution for community visibility. Appreciate Your Kudos 🙂

[Ncio]

Thank you!