Forum Discussion
Create multi row card with latest date and text value
Thank you all! Yes, the filter was the issue. I was able to come to a solution with the following code:
most recent testing criteria = VAR Most_recent_date_testing = [Most recent date testing]
RETURN
CALCULATE(MAX([who_criteria_testing_last]), FILTER(ALL('who_criteria (2)'), 'who_criteria (2)'[Date] = Most_recent_date_testing))
Community Championjg84 Seems like you should just be able to put the value in the card and choose a default aggregation like first or max
That's what I thought as well but it doesn't seem to update when I change the country on the slicer. It remains at "Criteria Not Met" When it should say "Criteria Met" for this selection.
jg84
You should also filter the target column or measure, try the following measure. See my example:Measure = CALCULATE(MAX([Date]), FILTER('Table',[who_crieria_testing]<>BLANK()))
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you all! Yes, the filter was the issue. I was able to come to a solution with the following code:
most recent testing criteria = VAR Most_recent_date_testing = [Most recent date testing]
RETURN
CALCULATE(MAX([who_criteria_testing_last]), FILTER(ALL('who_criteria (2)'), 'who_criteria (2)'[Date] = Most_recent_date_testing))