fillter result by date for lastdate

[islam_zaki]

Hi All 

I need to get only the last sales date as one date, now this DAX :

LastDate NetSales = CALCULATE([Sales ExVAT/ExCHARITY],LASTDATE(SALESTRANSACTION[SALES DATE]))

Giving the last date of each store, may this date have no sales for some stores. 

example : 

Thanks in Advance...

[amitchandak]

@islam_zaki , You have to try something like

Measure =
VAR __id = MAX ('Table'[Store] )
VAR __date = CALCULATE ( MAX('Table'[Date] ), ALLSELECTED ('Table' ), 'Table'[Store] = __id )
CALCULATE ( sum ('Table'[sales] ), VALUES ('Table'[Store] ),'Table'[Store] = __id,'Table'[Date] = __date )

[islam_zaki]

@amitchandak Thanks for supporting, 

i try the above measure but its fail as below :