Forum Discussion
Helper IAttendance or count based on 2 fields
Hi rains_23
There is too little information to see from this screenshot, could you please create a matrix visual showing us the problem you are experiencing using the sample data from the initial post?
And describe all the relevant fields in the matrix and the measures that might be used.
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.
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
- rains_23
Card 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.