Reply
Regular Visitor
Posts: 19
Registered: ‎02-03-2016

DAX custom score challenge

 

Hi,

 

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?

Thanks!