Find my approach as reference below and stored in attached workbook version 2018.2 located in the original thread
1. Upfront: I had to add an unique indicator to the data set as depicted above.
2. define measure M1. Display Cleaned Data:
if attr([Status])='Acces Card' then attr([Card Id])
elseif attr([Status])='Door Open' then LOOKUP(attr([Card Id]),-1)
elseif attr([Status])='Door Close' then LOOKUP(attr([Card Id]),-2)
3. Drag required objects to the indicated locations
Hope it helps.
This works. Thanks.
Perfect!:) Please close the thread with a helpful or Correct Answer so the community is aware and they can focus on other threads,
Your cooperation is much appreciated.
Have a nice day