Value of indicator based on date slicer

[Anonymous]

Hi everyone,

I need some help to resolve my issue.

My data :

I'd like to repeat the sales value of the first date on all lanes like that :

I need this value to be filtered by a date slicer. If i filter my date, i want the value to be like that :

I tried many things, but i can't resolve it.

Can anyone help me please ?

Regards,

[Anonymous]

Just duplicate your date column give him name ex. date1, put this date1 as filter.
Now create below measure:

Measure = CALCULATE(FIRSTNONBLANK('Table'[Sales],1),ALL('Table'[Date]))

It will work fine.

Optional: You can rename date1 to date, in formatting pane if required.

[Anonymous · Accepted solution]

Thanks for your reply.

It didn't work because 1 line in my table was many lines of details.

But i found a solution :

Measure =

var selected_min_date = CALCULATE(MIN(Table[Date]),ALLSELECTED(Table[Date]))

RETURN

CALCULATE(

sum(Table2[Sales]),

FILTER(

ALL(Table),

Table[Date] = selected_min_date

)

)