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.
Super Usertry this:
CurrentStatus :=
VAR IsFiltered =
ISFILTERED('Calendar'[Quarter]) || ISFILTERED('Calendar'[Year])
VAR SelectedLinkedDate =
IF(
IsFiltered,
MAX(ActivityTable[Linked]), -- Use the latest date in selected period
CALCULATE(
MAX(ActivityTable[Linked]),
ALL(ActivityTable) -- Ignore slicers if nothing is selected
)
)
RETURN
CALCULATE(
MAX(ActivityTable[Status]),
FILTER(
ActivityTable,
ActivityTable[Linked] = SelectedLinkedDate
)
)
Using this formula, when no specific quarter/year selected, it display Ongoing instead of Completed.
Can you assist?
