Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I am trying to have the total Labor hours which is a measured column within the table public_work_order_logs per each class which is in its own table public_classes.
But as you can see it is giving me the total sum for each class. How can i fix this?
Below is my schema as well and i highlighted each column from the tables that i am usuing.
Solved! Go to Solution.
I found the issue it had to do with the relationships between my tables
I found the issue it had to do with the relationships between my tables
@ghe7549 Well, something is either a measure or a calculated column. Looks like your Labor Hours is a calculated column. If I am reading your data model correctly the issue seems to be that your Class column (Name in public classes table?) is not related to your public works order log table and thus your Labor Hours calculation. You will need relationships defined with the directions of those relationships such that the first table filters the other. Also, it is almost certain that if Labor Hours is a calculated column you will need this to be a measure instead.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
117 | |
101 | |
71 | |
61 |