I have two sets of table as below:cust_nameABCJohn553Mary 3 Ken 4 cust_nameCDEJohn2 1Amy14 Julia6 1 How can I combine and sum the column C in visualisation as below: cust_nameABCDEAmy 14 John555 1Julia 6 1Ken 4 Mary 3 The two original tables were formed based on different level of breakdown and the level of breakdown does not work parallel with each other. Some of the breakdown will be coincidentally having the same name at a particular level. Thus, is that possible not the append the table, but applying the summation with the same name at the visualization level? Can it also be applied to the same scenario each time i change the level of breakdown?

after appending the queries for tables,you can create a dax query to summarise the data for the same name

Combine two columns with same name from different table in visualisation