Forum Discussion
Helper IAttendance or count based on 2 fields
Helper ISorry, I was going to post the data I used. All are simple columns. Month is a colum duplicated from Login date. with month format. What it is doing is it is taking the total as 21 in above example, that is number of employees in the month of jan. and not no. of occurence. So If an employee is in month of jan 3 times, it is counting as 1 and not 3
Helper ICard details - is employee name
Hi rains_23
Based on your description, I think you were expecting the totals to be count of Login Date, but the actual result in your matrix looks like count of employee, is that correct? Please correct me if I have misunderstood.
However, I am not able to reproduce the problem using sample data.Please check the following first:
1. Check the field settings:
Make sure the Employee, Division and Month fields are not incorrectly set as row labels or key column.2. Data Model Relationships:
Make sure that the Login Date column has the correct relationship to the other tables and that there are no many-to-many relationships.If the problem persists, please create a simple sample Power BI file with sample data to reproduce the problem and share your pbix file here.
Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.- rains_23
Hi,
Unfortunately I am not able to find the Row Label and Key Column properties in my version.
Hi rains_23
In the model view, select your table to see the Row lable and Key column.
As stated in the previous reply, if possible, please create a Power BI file using simple sample data and reproduce the problem, then share that Power BI file here and we'll try to find the cause of the probelm and solve it.
Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.