Problem with dynamic filters

Try

Measure 3 = 
VAR __date = MAX ( Table1[DATE] )
VAR __city = CALCULATE ( MAX( Table1[CITY]), ALLSELECTED ( Table1 ),  Table1[DATE] = __date ) 
RETURN CALCULATE ( [M Score] ), VALUES ( Table1[CITY] ), Table1[CITY] = __city, Table1[DATE] = __date )

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin

Hi amitchandak 

Well done and thank you.

Playing around with the code I found I didn't need the reference to City and the cause of the problem was that I needed to have the 'latest visit date' not as a separate measure but as a variable in the main measure. Not sure I fully understand this yet, need to do some more experimenting!

Thanks

Brian