FInd Max Value for a Date and Customer and then display that value in ALL dates

[earltom]

The original data is on Top and my attemped solution is below that , the data is time dependant so it may change as year goes by.

I am able to get the data for the date selected but I would like it to display/overwrite in all rows/dates for that customer

DAX

sel_we_dt is a measure - Selected Value (date)

mTest3 = CALCULATE(MAX('Store List'[scan_lfl]),FILTER(('Store List'),[date_sk]=[sel_we_dt]))

[earltom]

Customer	End of Week	Good/Bad Store Ind	Sales
276	6-Mar-22	N	1000
276	13-Mar-22	Y	2000
276	20-Mar-22	Y	1500
276	27-Mar-22	Y	1700
276	3-Apr-22	N	800

A store has sales every week and they ae classified as good or bad store by its Sales ,if a user makes a data selection I want the Good/Bad Indicator to overwrite the other weeks to that weeks Good/Bad Ind.

So if 27-Mar-22 is selected then the table should be :

Customer	End of Week	Good/Bad Store Ind	Sales
276	6-Mar-22	Y	1000
276	13-Mar-22	Y	2000
276	20-Mar-22	Y	1500
276	27-Mar-22	Y	1700

or  3-April-2022 is selected then table should look like this but there are multiple customers so it needs to be grouped by each customer

Customer	End of Week	Good/Bad Store Ind	Sales
276	6-Mar-22	N	1000
276	13-Mar-22	N	2000
276	20-Mar-22	N	1500
276	27-Mar-22	N	1700
276	3-Apr-22	N	800

[amitchandak]

@earltom , The information you have provided is not making the problem clear to me. Can you please explain with an example.
refer if this blog can help

https://medium.com/chandakamit/power-bi-when-i-felt-lazy-and-i-needed-too-many-measures-ed8de20d9f79

Instead of max date based on selection, it can based on customer

calculate(Max(Table[Date]), filter(allselected(customer), Customer[ID] = max(Customer[ID]) ) )

Appreciate your Kudos.

[earltom]

The date is a selected value