I’ve reviewed very comparable problems and their solutions including this one here:
Unfortunately, I can’t quite translate either the “SUMX (SUMMARIZE …” logic or the HASONEFILTER logic to my DAX Measure.
I only want to get the latest data in the source list, depending on how far I have drilled down/up within a matrix visual. I’ve been using the following measure in order to get this behavior:
Latest Critical Item = LASTNONBLANKVALUE(ExecMetrics[Critical Items Past SLA], MAX(ExecMetrics[Critical Items Past SLA]))
The two rows are correct at any level, but the totals are not.
I’d appreciate hearing how you would solve this problem.
Joel - DataChamp Upload.pbix (1.8 MB)