Forum Discussion
Bridge Tables
I think the simplest solution would be to create a calculated table that contains unique Team data, and create the necessary calculations on this table. Something like:
TEAM =
SUMMARIZE(<2nd Fact Table>, <2nd Fact Table>[TEAM], <2nd Fact Table>[DATE])
Then create a calculated columns on the new TEAM called "Amount Overtime" which calculates the sum of overtime from your first table (ERP). This way you have the sum for overtime for each team on each date.
But how would this new table relate to the point table?
If you only need to "create a chart that shows OVERTIME BY TEAM", then the new calculated table does not need to be related, and the chart can use the new calculated table as the data source. If additional charts/data points are needed, you could related the new TEAM table to your other table by the "team name" column on the original table. But depending on your other need for other charts/visualizations, additional steps may be required.
Okay, I don't know if I understand very well... Could you give me an example of how I would calculate the total overtime (taking it from the first table) since it doesn't have a team column? Would you do this by measure?
