Forum Discussion
Get latest status based on same identifier
HI IkmalFikri900
The file shared by Ashish_Excel provides accurate results as per the request.
To display 200 in your card, I would recommend using Latest measure where it will correctly display the expected value.
See below image for reference-
Reuploadiing the pbix for reference.
If the above information is helpful, please give us Kudos and mark the response as Accepted as solution.
Best Regards,
Community Support Team _ C Srikanth.
Community SupportI wanted to follow up since I haven't heard from you in a while. Have you had a chance to try the suggested solutions?
If your issue is resolved, please consider marking the post as solved. However, if you're still facing challenges, feel free to share the details, and we'll be happy to assist you further.
Looking forward to your response!
Best Regards,
Community Support Team _ C Srikanth.
Hi, apologies for the reply,
I still havent' been able to resolved the issues.ID LinkedID Date StatusUpdate Values IssueStatus 1 1 1-Jan-25 Update 1 100 Ongoing 2 1 2-Feb-25 Update 2 150 Completed 3 3 1-Jan-25 Update 3 200 Ongoing 4 3 2-Feb-25 Update 4 200 Ongoing So, the expectation is, when User filter ALL Date Column, visuals should display 1 Ongoing and 1 Completed
While if the user select January, it should be 2 Ongoing case 0 Completed
The issue is i can use Measure but i want to use card to visualize the number of case and values where i can filter using just Status.
So i have to use calculated column where the expected results is:When no filter is selected:
ID LinkedID Date StatusUpdate Values IssueStatus Latest Status 1 1 1-Jan-25 Update 1 100 Ongoing Completed 2 1 2-Feb-25 Update 2 150 Completed Completed 3 3 1-Jan-25 Update 3 200 Ongoing Ongoing 4 3 2-Feb-25 Update 4 200 Ongoing Ongoing But when January is Selected (The table is filtered)
ID LinkedID Date StatusUpdate Values IssueStatus Latest Status 1 1 1-Jan-25 Update 1 100 Ongoing Ongoing 3 3 1-Jan-25 Update 3 200 Ongoing Ongoing Is this possible?
