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 tab...
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 🙂

     

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 🙂

 

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

    Thank you!