Create a sum slicer that should change with changes in date slicer

[navin1491]

I have a transactional data base that contains ID, Date, Sales. I have aggregated sales value at the ID level and can filter by using Date

Snapshot of data

Using the following data, I've created a cumulative sales value at the ID level, that changes with the date filter

sumsales = CALCULATE (
    sum ( 'Sheet1'[Sales] ),
    FILTER (
        'Sheet1',
        'Sheet1'[Date] >= MIN ( 'Sheet1'[Date] )
            && 'Sheet1'[Date] <= MAX ( 'Sheet1'[Date] )
    ))

I now want to use to above sumsales as a filter, so that when date filter is changed, the corresponding values in the sumsales filter should also change. For example, if I choose the date range slicer to be between 09/01/2018 - 12/01/2018, the sumsales filter should only contain values for that time period. Can someone please help me here. 

Attaching the link of the sample powerBI. 

https://drive.google.com/open?id=11of5z6dcD5Fa6Z-Ynfz2O9WbGC0erMQ4

Thank you in advance.

[v-frfei-msft]

Hi @navin1491,

The measure will be changed by the date slicer by default . However, as I know, we cannot filter the table by a measure. 

---

I now want to use to above sumsales as a filter, so that when date filter is changed, the corresponding values in the sumsales filter should also change. For example, if I choose the date range slicer to be between 09/01/2018 - 12/01/2018, the sumsales filter should only contain values for that time period. 

---

If you choose the date range slicer, then the table will be filterd at the same time. Then the measure will be changed accrodingly. Please figure it out if I did not understand.

Regards,

Frank