Calculated column to show if a value in a related table exists

[Jwah]

Hi all, i thought this was simple but am new to PowerBI and have obviously found myself in a deep end.

I have 2 related tables i want to check if a value exists on the "many" side. 

In the Applications table, i want a flag to show if a task type of "Form Received" for that application ID exists in the Task table. 

The yellow column is what i want to create

[danextian · Accepted solution]

Hi @Jwah ,

Try this as a calculated colum in application table.

=
NOT (
    ISBLANK (
        CALCULATE (
            COUNTROWS ( 'task' ),
            FILTER (
                'task',
                'task'[task_type] = "Form Received"
                    && 'task'[applicationid] = EARLIER ( 'application'[applicationid] )
            )
        )
    )
)

This will count the rows where task type =form received and the applicationid matches the current row applicationid. If it doesn't return blank then the conditions are met.