Forum Discussion
Using Match Tables to create combined values in visualisations
Hi, I resolved this issue by completely re-making the report but this time appending the data instead. Both tables had many overlapping columns, and so after some formatting they appended together perfectly. This then resolved all of the problems that I was incountering with creating totalled values from both tables and with correcting the way that visuals where behaving.
Thankyou for your help
Create a measure for each table, and then a measure that adds the two measures together. Something like this:
Total Measure = [Table 1 Measure] + [Table 2 Measure]
Do you have a master project table (e.g., DimProject)? This table would have a relationship with the two fact tables, and you would use DimProject columns and [Total Measure] in your visuals.
Hi, I resolved this issue by completely re-making the report but this time appending the data instead. Both tables had many overlapping columns, and so after some formatting they appended together perfectly. This then resolved all of the problems that I was incountering with creating totalled values from both tables and with correcting the way that visuals where behaving.
Thankyou for your help