Hi all members,
I need help in creating a measure to count the number of Message_id by users under each department separately. I also want to show the data with heatmap custom visual. I have two tables with the following details:
Messages: Message_id, User_id
Users: User_id, User_name, Department
The two tables are linked by User_id. The Message_id has unique values so the measure can be a COUNTROWS function. Looking forward to your suggestions!