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.
I 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?