Hi @Anonymous
Understood - have updated the file at the same dropbox link.
I created another measure to user in the matrix for this purpose. At least this works, but there may well be better ways to write it.
Serial Numbers Returned Summed Monthly (only if Second Return in Most Recent Month ) =
VAR LatestMonth =
CALCULATETABLE ( LASTDATE ( 'Calendar'[Month] ), ALLSELECTED ( 'Calendar' ) )
RETURN
SUMX (
SUMMARIZE (
'Defect Found',
'Calendar'[Month],
'Defect Found'[Serial Number],
'Defect Found'[Failure Code]
),
IF (
NOT ( ISBLANK ( CALCULATE ( [Serial Numbers Second Return], LatestMonth ) ) ),
[Serial Numbers Returned in Most Recent Month]
)
)Using this measure in a matrix, you can see when the 164 "Second Returns" in March were returned in earlier months.
Regards,
Owen
