Sum where date = another date

[NewbieJono]

i wish to sum a volume where the dates in a coloumn equals a certain date (Calculated from another measure)

This does not seem to work

Oldest Date Volume = 

VAR Volume =
CALCULATE(
    SUM(DATA[Volume]),
    [Oldest Date] = DATA[Date of Receipt]
)

Return

Volume

[amitchandak · Accepted solution]

@NewbieJono , Try like

Oldest Date Volume =

VAR Volume =
CALCULATE(
SUM(DATA[Volume]),
filter(DATA, [Oldest Date] = DATA[Date of Receipt])
)

Return
Volume

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.