show developer availability based on condition (show in table or matrix or visual)

[pasupathi]

Dear Helper 

  please kindly read the complete data. kindly share the powerbi file 

table A

 developer projectstatus  

   a                fsd

   b                uat

   c                hypercare

   d                dev

   e                devloper allocated

   f                 live 

table B
developer    teammanger  
  a                subbu

  b                subbu

  c                subbu

  d                subbu

  e                subbu

  f                subbu

  g               subbu 

  h               subbu

condition

1. join the two tables

2. show developer who are not in fsd,uat,live

3. show developer who doesnt have project status

regards

rasi

[ddpl · Accepted solution]

@pasupathi 

2. show developer who are not in fsd,uat,live

 Create measure as per below:

Condition 2 =
CALCULATE (
    MAX ( TableA[project status] ),
    TableA[project status] <> "fsd",
    TableA[project status] <> "uat",
    TableA[project status] <> "live"
)

 3. show developer who doesnt have project status

Create column in TableB as per below

project_status = LOOKUPVALUE(TableA[project status],TableA[developer],TableB[developer])

then filter by slecting blank as per below snap