Forum Discussion
Issue with Completed Projects Count Measure for Year-Month Line Chart
Hi dk_dk
Thanks for your reply, the half of the issue is solved , i created latest date column and am used a logic to find latest date and am using that in my visual this is working fine but here the issue is i have Client,Employee,Project as slicers
for example
| Project | Date | To | Client | Employee | Status | StatusBasedOnMaxDateTimeColumn | Latest Date |
| ProjectA | 01-10-2024 | 08:00:00 | CEA | Lewis | In Progress | Completed | |
| ProjectA | 05-10-2024 | 17:32:00 | CEA | Lewis | Completed | Completed | |
| ProjectA | 15-11-2024 | 19:00:00 | JR | Vettel | In Progress | Completed | |
| ProjectA | 15-11-2024 | 20:00:00 | JR | Vettel | Completed | Completed | 15-11-2024 |
| ProjectB | 02-10-2024 | 06:04:00 | RAC | Leclerc | In Progress | In Progress | |
| ProjectB | 03-10-2024 | 13:31:00 | RAC | Leclerc | Completed | In Progress | |
| ProjectB | 19-10-2024 | 01:15:00 | DOC | Max | In Progress | In Progress | |
| ProjectB | 01-11-2024 | 19:00:00 | DOC | Max | In Progress | In Progress |
if i select projectA in the slicer its working fine , if i select client JR it will working fine ,but i need to show something like even if we select CEA(client) also i should show as the project is completed ,the count should be in the Nov 2024 like same for Employee slicer
(i.e) under single project we have multiple clients and vice-versa,under single project we have multiple employees also
the ultimate goal is to match the completed count which present in the table visual should match with the line chart even if we aggreate the count also
Ah I see,
So basically you want 15-11-2024 to be the value in the first 3 rows of your sample data as well (in the Latest Date column)?
Could you share the DAX you used for Latest Date?
Best regards,
Daniel