Forum Discussion

Ncio's avatar
Ncio
Icon for Helper II rankHelper II
4 years ago
Solved

Count rows with no rows in a related table

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!

Need Help
  • SpartaBI's avatar
    SpartaBI
    4 years ago

    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 🙂

     

2 Replies

  • SpartaBI's avatar
    SpartaBI
    Icon for Community Champion rankCommunity Champion
    4 years ago

    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 🙂