Count Rows , Related Table > 1

[lcasey]

Hello,

I am trying to count rows of a related table , but only if the related table has more than 1 record. Here is my formula,

Launched Accounts = CALCULATE(COUNTROWS('Cases'),RELATEDTABLE(Events) > 1)

But it produces an error: The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.

How can I count rows in a related table only if the related table has more than 1 related record?

Thanks!

[selimovd · Accepted solution]

Hey @lcasey ,

you can just return BLANK if the number is 1 or smaller. Try the following calculated column:

Launched Accounts =
VAR vRowsRelated =
    CALCULATE(
        COUNTROWS(
            RELATEDTABLE( Cases )
        )
    )
RETURN
    IF(
        vRowsRelated > 1,
        vRowsRelated,
        BLANK()
    )

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[lcasey]

Thank You!