Forum Discussion

cherrybi_com's avatar
cherrybi_com
Frequent Visitor
2 years ago
Solved

Project with no customer associated

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)

Need Help
  • amitchandak's avatar
    amitchandak
    2 years ago

    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

     

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    2 years ago

    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