Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Jwah
Frequent Visitor

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

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

Jwah_0-1705547774706.png

 

1 ACCEPTED SOLUTION
danextian
Super User
Super User

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.










Did I answer your question? Mark my post as a solution!


Proud to be a Super User!









"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

View solution in original post

1 REPLY 1
danextian
Super User
Super User

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.










Did I answer your question? Mark my post as a solution!


Proud to be a Super User!









"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.