Project with no customer associated

[cherrybi_com]

3 tables - project, property, customer

project is connected with property and property is connected with customer.

I need to find out

1. all projects that have not yet had a customer entered for them

2.  all projects that have had a customer entered for the linked property (from the first customer)

[amitchandak · Accepted solution]

@cherrybi_com ,

all projects that have not yet had a customer entered for them

Following measures 

M1 = countrows(Customers)

all projects that have not yet had a customer entered for them = countx(projects, if(isblank([M1]) , Project[ID], blank() ) )

all projects that have had a customer entered for the linked property (from the first customer) , I think measure M1 should do that