Sep 24, 2018 ยท I am using the below measure which seems to work unless the most recent score is a "0" in which case it pulls through the most recent non "0" score. Most Recent Score = VAR MRSM = Master [Employee ID] RETURN CALCULATE ( LASTNONBLANK ( Master [Score], Master [Score] ), FILTER ( Master, Master [Employee ID] = MRSM ) ) Please format code as code .... "/>