Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Multiple tables lookup with multiple column filters by value

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:                                                         

ProjectNameDepartment
AName1Dep1
BName2Dep2
CName3Dep3
DName4Dep1

 

Table2:

ProjectSigned ByProcess
ATechImplementation
ABusinessImplementation
AQualityInitiation
BTechImplementation
BBusinessInitiation
BQualityInitiation
BTechInitiation
BBusinessInitiation
BBusinessClose
CTechInitiation
CBusinessImplementation

 

So, looking to get something like this:

Total ProjectsProjects with 1 approval missingProjects with 2 approvals missingProjects with 3 approvals missing
#   

 

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

multiple column
multiple date tables

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

    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.