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,
I have explained issue below, help is appreciated
I have data like
EmpID | Taining | Status |
1 | PhysicalSecurity | Dropped |
1 | PhysicalSecurity | Completed |
1 | Client Relation | In Progress |
2 | PhysicalSecurity | In Progress |
2 | PhysicalSecurity | Dropped |
3 | Client Relation | In Progress |
3 | Client Relation | Dropped |
3 | Client Relation | Incomplete |
3 | Client Relation | No Show |
3 | PhysicalSecurity | Dropped |
3 | PhysicalSecurity | Completed |
4 | PhysicalSecurity | In Progress |
4 | PhysicalSecurity | Dropped |
4 | Client Relation | In Progress |
4 | Client Relation | Dropped |
11 | PhysicalSecurity | Dropped |
11 | PhysicalSecurity | Completed |
11 | Client Relation | In Progress |
12 | PhysicalSecurity | In Progress |
12 | PhysicalSecurity | Dropped |
13 | Client Relation | In Progress |
13 | Client Relation | Dropped |
13 | Client Relation | Incomplete |
13 | Client Relation | No Show |
13 | PhysicalSecurity | Dropped |
13 | PhysicalSecurity | Completed |
14 | PhysicalSecurity | In Progress |
14 | PhysicalSecurity | Dropped |
14 | Client Relation | In Progress |
14 | Client Relation | Dropped |
i need report like
Training | Completed | In Progress | Incomplete | Dropped | No Show | Totals |
PhysicalSecurity | 4 | 4 | 0 | 0 | 0 | 8 |
Client Relation | 0 | 6 | 0 | 0 | 0 | 6 |
Totals | 4 | 10 | 0 | 0 | 0 | 14 |
This is because employee can attempt multiple times ,
So, need to get counts using below logic
Get Distinct Emplyee ID Count for Completed Status
Exclude Emplyee ID for completed and get Distinct Emplyee ID Count for In Progress Status
Exclude Emplyee ID for completed, In Progress and get Distinct Emplyee ID Count for Incomplete Status
Exclude Emplyee ID for completed, In Progress, Incomplete and get Distinct Emplyee ID Count for Dropped Status
Exclude Emplyee ID for completed, In Progress, Incomplete,Dropped and get Distinct Emplyee ID Count for No Show Status
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 |
---|---|
12 | |
2 | |
1 | |
1 | |
1 |