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 two talbes Jobs and Dates with the date as the relationship. I wish to count the individual people (name) to see how many jobs they have completed (job status) for the month on in one column and a seperate column for the the week.
thank you
Job Table | >>>>>>>>> | Dates Table | |||||||||||
Name | Job Status | Job Reference Number | Date | Date | Year | Month | Week | ||||||
Jim | Completed | 23254 | 01/07/2019 | 01/08/2019 | 2019 | July | 14 | ||||||
Jim | Completed | 454545 | 02/07/2019 | 02/08/2019 | 2019 | July | 14 | ||||||
Jim | Completed | 54545 | 03/07/2019 | 03/08/2019 | 2019 | July | 14 | ||||||
Jim | Completed | 54545 | 04/07/2019 |
| 04/08/2019 | 2019 | July | 14 | |||||
Jim | Completed | 445454 | 05/07/2019 | 05/08/2019 | 2019 | July | 14 | ||||||
Bob | Completed | 836363 | 06/07/2019 | 06/08/2019 | 2019 | July | 14 | ||||||
Bob | Completed | 1227272 | 07/07/2019 | 07/08/2019 | 2019 | July | 14 | ||||||
Bob | Completed | 1618181 | 08/07/2019 | 08/08/2019 | 2019 | July | 15 | ||||||
Bob | Completed | 2009090 | 09/07/2019 | 09/08/2019 | 2019 | July | 15 | ||||||
Gary | Completed | 2399999 | 10/07/2019 | 10/08/2019 | 2019 | July | 15 | ||||||
Gary | Completed | 2790908 | 11/07/2019 | 11/08/2019 | 2019 | July | 15 |
Solved! Go to Solution.
Hi @cottrera
Create measures as below
And add columns from calendar table in a matrix visual
Measure = CALCULATE ( DISTINCTCOUNT ( Sheet2[Job Reference Number] ), FILTER ( Sheet2, Sheet2[Name] = MAX ( Sheet2[Name] ) && Sheet2[Job Status] = "Completed" ) )
Hi @cottrera
Create measures as below
And add columns from calendar table in a matrix visual
Measure = CALCULATE ( DISTINCTCOUNT ( Sheet2[Job Reference Number] ), FILTER ( Sheet2, Sheet2[Name] = MAX ( Sheet2[Name] ) && Sheet2[Job Status] = "Completed" ) )
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 |
---|---|
110 | |
94 | |
80 | |
67 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |