select MIN date of relative date slicer in every row of table

[Anonymous]

Hi! I have this measure:

Measure = 
VAR FECHA = CALCULATE(MIN('DATA BASE'[DATE]),ALLSELECTED('DATA BASE'[DATE]),VALUES('DATA BASE'[resp x dep 2]))
RETURN FECHA

and in my table is returning me this:

i want to force the measure to only display the values that have information in the MIN date selected in the slicer. Similar as when I select the specific date:

I will use this variable for another measure

Thank you for the help!!

[amitchandak]

@Anonymous , try like

Measure =
var _min = minx(allselected('DATA BASE'),'DATA BASE'[DATE])
RETURN
CALCULATE(MIN('DATA BASE'[DATE]),filter('DATA BASE','DATA BASE'[DATE]=_min ))

[lbendlin]

The slicer needs to be fed from an independent date table.

Create a measure that compares your fact date to the min slicer date

Show Row :=
VAR FECHA = MIN('SLICER'[DATE])
Return 'DATA BASE'[Start]=FECHA

Then filter the visual by Show Row = True