Model to oversee the customer systems to avoid snooping by employees

[AndCamPed]

Halo everybody. 

Currently, I'm making a model to oversee the usage of the customer systems in my business. The purpose is to identify snooping. Meaning, one employee is looking at information about customers the person is NOT responsible for.

I have two tables; 

1. one with all the log data. Who looked up a given customer at a given time.
2. And one customer table with information about the customer and their customer manager 

The tables look something like this: 

From the table above, we can see that Jill has been snooping on Jon's customer and that the action is marked:

I want to create a new column that indicates that "log_id" nr 4 is marked, and the rest is ok. Something like this:

I am open to other solutions as well.
But I need help with the DAX formula/expression to make the new column "Odd_bihavior".

Thank you, Andy

[Jihwan_Kim · Accepted solution]

Hi,

I am not 100% sure if I understood your question correctly, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file if it suits your requirement.

Odd behavior CC =
VAR _customermanager =
    RELATED ( Customer[Customer_manager] )
VAR _result =
    IF ( 'Log'[Employee_ID] <> _customermanager, "Marked", "OK" )
RETURN
    _result

[AndCamPed]

Thank u!
This solution worked with my actual data. 🤓