The result is the total sum of the values of each [Amount PL]. And with a filter at teh matrix I'm able to show the value of each Company.
But(!), when I add the same row for Company3, it brings me a complete wrong value. What is the beste solution / DAX formula to calculate the values of each Company and I can filter later on in a matrix?
Sorry, I don't have more information. Many thanks for your help!
Before you append the tables, make sure that you have a company column in each table specifying which company the rows are related to. When you have this you should be able to use that column as a column/row dimension or a filter in a slicer.