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))
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))