Forum Discussion
Another Relationship Issue
I actually used this approch somewhat, although I had to use a concatenate function below to get a unique key in the estimate table and the job cost table:
JobCostItem = Concatenate(concatenate(JC_JobEstimatesOriginal[JobNumber],JC_JobEstimatesOriginal[CostItem]),JC_JobEstimatesOriginal[CostType])
Not sure if there was a better formulae to combine the three columns, but you're right. Once I had these two tables linked properly everything worked great!
ntravis I have run into similar issues in past. since there is no active relationship between estimate and cost table you won't be able to visualise them in a single visual together. If you click on field dropdown under Axis and choose Don't summarize, visual will throw error. What you need to do is one of below,
1. either use cost and estimate from one table ie estimate table
2. create two visuals side by side one with job number and estimate and other with job number and cost