Measure

[Volvo_Chang]

Hello Team,

I have net cases number pulled from daily invoice database. I want to show the net cases in the table as the table1 below based on the date range. However, I have used the measure as below but get the net cases combined instead of row by row. Can you please help me how to adjust my measure to get it to work? Thanks.

NetCases = calculate(sum('summary InvoiceDCByDay'[NetCases]),filter('Pricing',average('summary InvoiceDCByDay'[InvoiceDate])>=Pricing[Valid After] && average('summary InvoiceDCByDay'[InvoiceDate])<=Pricing[Valid Before]))

Net Cases	Price Start Date	Price End Date
100	4/1/2019	5/1/2019
108	5/1/2019	6/1/2019
5	6/1/2019	7/1/2019

This one below is what it look like in my table, after the measure I enter:

Adjusted Cases	Price Start Date	Price End Date
	4/1/2019	5/1/2019
213	5/1/2019	6/1/2019
	6/1/2019	7/1/2019