How to get the absolute Min Value of a Date Slicer in a measure?

[Anonymous]

I am trying to create a measure that uses a date slicer which has a "To" and "from" date. The Measure needs to use the "To" date in a dateslicer to select the corresponding Snapshot date to create a sum. 

Powerbi Filter: 28/08/2019 - 28/09/2019

My current MIN Measure:

Opening Sum =

VAR minTime = CALCULATE(MIN(sales[SNAPSHOT_DATE]),ALLSELECTED(sales))

 Return

CALCULATE(sum(SALES[AMOUNT]),FILTER(ALL(SALES[SNAPSHOT_DATE]),SALES[SNAPSHOT_DATE]=minTime))

The problem with this measure, is it does not actually select the value 28/08/2019, it just selects what ever the MIN value is for a Sale ID/Person within the selected date slicer period.

Example:

In this example, the Sale is swapped from one Sales Person to another. The issue is both users are showing up in the measure with a value of 301.31.

The first sale occurs on the 29/08 which is the actual MIN date, then later on the 17th it is swapped to another sales person which is not the Absolute Min on the 17th/09. Is there something i am missing in my dax?

I just want to say 

Sum of all things that share the same snapshot date as the Slicers min date?

[v-eachen-msft]

Hi @Anonymous ,

I am not clear about what you want. Could you please share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

Maybe you can create a new table with column of date. Then create a slicer based on it. 

[amaleranda]

@Anonymous 

Can you please put a sample of your datamodel file.

if you can email I will provide you my email.