Multiple tables lookup with multiple column filters by value

[radar]

Hi Friends - I'm having trouble solving this and would greatly appreciate your help:

I have two tables with many columns: using sample fake data for easiness. Table1 has project details, Table2 has approval detials. I want to get a count (with drilldown to see details) of projects that have all required approvals, projects with 1 missing approval, projects with 2 misisng approvals, projects with no approval.

Table1:                                                         

Project	Name	Department
A	Name1	Dep1
B	Name2	Dep2
C	Name3	Dep3
D	Name4	Dep1

Table2:

Project	Signed By	Process
A	Tech	Implementation
A	Business	Implementation
A	Quality	Initiation
B	Tech	Implementation
B	Business	Initiation
B	Quality	Initiation
B	Tech	Initiation
B	Business	Initiation
B	Business	Close
C	Tech	Initiation
C	Business	Implementation

So, looking to get something like this:

Total Projects	Projects with 1 approval missing	Projects with 2 approvals missing	Projects with 3 approvals missing
#

with drilldown to see details and also add slicers for Department and other required columns. Please help

[lbendlin]

You don't indicate how to identify "approval" in your data. Is it "Implementation"?

Generally you create measures in DAX that calculate these data points per your rules, taking filters into account.