02-10-2017 02:07 AM
Here is the situation. I have two tables: "Messages" and "Users" which are related throught User_id.
Mesagges: Message_id, Replied_to_id, User_id
Users: User_id, User_name, Department
What i want to do is to create a measure that will calculate some custom Score.
Score = If the user replied to a post made by a user from a different department, it counts as 2. If the user replied to a post made by a user from the same department, it counts as 1. If the post does not have Replied_to_id (Initial post), it counts as 0.
Does anyone have any suggestions how to do this?