Getting lowest value from filtered dates and using it in measure

[Anonymous]

Hi! 

I've got a report with one "page-level" filter that works for all my visuals except one. The filter is a date interval with start and end date inputs. The last visual I want to have disconnected from the filters date-interval, and rather have it look at the start date so that I can calculate the starting balance at that start date. 

Example. I have filtered from: 1.1.2019 - 31.12.2019 

- All (except last one) visuals show measures within that time interval

- Last measure harvests the start date from the filter and inputs that in a measure calculating ingoing balance up to that point. 

Is there a function to harvest this value from a dynamic filter?

[v-yiruan-msft]

Hi @Anonymous ，

Do you want to get the start date of date range in the date field which applied to the page-level filter? For example, the date (2014/5/1) circled round red in the below screenshot is the date you want to get?

In addition, maybe you can try to use sync slicer and check if it works in your scenario.

Best Regards

Rena

[amitchandak]

Did not get it> Bit if you looking to get first date from slicer

Measure =

var _min = minx(allselected(Date),Date[Date])

return

calculate([measure1],filter(Date[Date] =_min)

[EricHulshof]

If i understand correctly you want to use SELECTEDVALUE(Startdate)