total of sales based on one dim in table and with selection of other dim total should not change

[miranrai]

I have a table as below. My requirement is to get total sale by product . If i select order date = 9/8/2019, then total sale by product =34*12 and Total sale to date by product = total (total sale by product ) = 2259 and this number should not change with selection (but record should reduce as per selection . I hope this explains. 

Thank you for help.

attaching excel for reference.

Product	order date	logistic date	product id	order duration	name	description	sale	Total Sale by Product	Total sale to date by product
1	12/12/2020	16/07/2020	a1	23	abc	abc	12	276	2259
1	12/12/2020	18/07/2021	a2	12	xyz	xyz	34	408	2259
1	9/8/2019	16/07/2021	a1	35	abc	abc	45	1575	2259
2	9/9/2019	18/07/2022	a3	76	pqr	pqr	65	4940	11780
2	9/10/2019	16/07/2022	a4	90	lmn	lmn	76	6840	11780
3	9/11/2019	18/07/2023	a1	23	abc	abc	23	529	50864
3	9/12/2019	16/07/2023	a3	45	pqr	pqr	45	2025	50864
3	9/13/2019	18/07/2024	a2	45	xyz	xyz	654	29430	50864
3	9/14/2019	16/07/2024	a4	56	lmn	lmn	234	13104	50864
3	9/15/2019	18/07/2025	a2	76	xyz	xyz	76	5776	50864

[Kushal_Chawda]

@miranrai  is it not 45*35 for 9/8/2019 as per the data?

[miranrai]

@Kushal_Chawda  yes ..expression for Total Sale by Product = order duration * sale and Total sale to date by product = sum of Total Sale by Product by each product. sample excel you can refer

[Kushal_Chawda]

@miranrai  try below expressions

//Total Sale by Product
=sum({1}[order duration]*sale)*avg(1)

//Total sale to date by product 
=sum(total <Product>{1}[order duration]*sale)*avg(1)