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.
then pls provide more details about your request. what is the expected output?
Sample Data:
| 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 this
| Info | |
| Ongoing Cases | 1 |
| Completed Cases | 1 |
| Values | 350 |
Since for the latest item (ie February), the latest IssueStatus is Completed and Latest Value is 150 for LinkedID 1. but LinkedID 2 stays the same
When the user Filter January 2025 only, visuals should display:
| Info | |
| Ongoing Cases | 2 |
| Completed Cases | 0 |
| Values | 300 |
Since in January, both LinkedID 1 and 2 status is Ongoing and the value is 100+200