Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |