I created a new post because I could not reply to the original one, also now I can't add images, so there is an image that explains one of the errors better in the original post: https://community.powerbi.com/t5/Desktop/Assistance-with-Mesurare-relating-two-tables-in-a-Matrix-Vi...
Actual:
| Service_ID | Cost Type | USD | Month | Year | Country |
| 1 | Software | 10 | 1 | 2020 | Argentina |
| 1 | Hardware | 20 | 2 | 2020 | Argentina |
| 2 | Software | 5 | 1 | 2020 | Spain |
| 2 | Software | 5 | 2 | 2020 | Spain |
| 2 | Software | 5 | 3 | 2020 | Spain |
| 3 | Communications | 10 | 1 | 2020 | Argentina |
| 3 | Communications | 5 | 1 | 2020 | Brasil |
| 3 | Communications | 10 | 2 | 2020 | Argentina |
| 3 | Communications | 5 | 2 | 2020 | Brasil |
| 3 | Communications | 10 | 3 | 2020 | Argentina |
| 3 | Communications | 5 | 3 | 2020 | Brasil |
Budget:
| Service_ID | Cost Type | Country | Year | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| 1 | Software | Argentina | 2020 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 |
| 2 | Software | Spain | 2020 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 |
| 3 | Communications | Argentina | 2020 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 |
| 3 | Communications | Brasil | 2020 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 |
| Service_ID | Service_Name |
| 1 | Windows Licences |
| 2 | Autocad Licences |
| 3 | Internet Link |
ATD: Actual to Day
BTD: Budget to Day
TB: Total Budget
Matrix 1:
| Service Name | ATD | BTD | Dif | TB |
| (+) Windows Licences | 30 | 24 | -6 | 96 |
| ______Software | 10 | 24 | 14 | 96 |
| ______Hardware | 20 | 0 | -20 | 0 |
| Autocad Licences | 15 | 15 | 0 | 55 |
| ______Software | 15 | 15 | 0 | 55 |
| Internet Link | 45 | 45 | 0 | 180 |
| ______Communications | 45 | 45 | 0 | 180 |
Matrix 2
| Service Name | Argentina | Brasil | Spain | Total |
| | ATD | BTD | ATD | BTD | ATD | BTD | ATD | BTD | TB |
| (+) Windows Licences | 30 | 24 | | | | | 30 | 24 | 96 |
| ______Software | 10 | 24 | | | | | 10 | 24 | 96 |
| ______Hardware | 20 | 0 | | | | | 20 | 0 | 0 |
| Autocad Licences | | | | | 15 | 15 | 15 | 15 | 55 |
| ______Software | | | | | 15 | 15 | 15 | 15 | 55 |
| Internet Link | 30 | 15 | 15 | 30 | | | 45 | 45 | 180 |
| ______Communications | 30 | 15 | 15 | 30 | | | 45 | 45 | 180 |
Matrix 3
| Service Name | 1 | 2 | 3 | 4 | ... | 12 | Total |
| | A | B | A | B | A | B | A | B | ... | A | B | A | B |
| (+) Windows Licences | 30 | 8 | 0 | 8 | 0 | 8 | | 8 | … | | 8 | 30 | 96 |
| ______Software | 10 | 8 | 0 | 8 | 0 | 8 | | 8 | … | | 8 | 10 | 96 |
| ______Hardware | | | 20 | 0 | | | | | … | | | 20 | 0 |
| Autocad Licences | 5 | 5 | 5 | 5 | 5 | 5 | | 5 | … | | 5 | 15 | 55 |
| ______Software | 5 | 5 | 5 | 5 | 5 | 5 | | 5 | … | | 5 | 15 | 55 |
| Internet Link | 15 | 15 | 15 | 15 | 15 | 15 | | 15 | … | | 15 | 45 | 180 |
| ______Communications | 15 | 15 | 15 | 15 | 15 | 15 | | 15 | … | | 15 | 45 | 180 |
- There is an slice with the year to filter, that only allows to check one year at a time.
- The matrix shows a line for each service, even if they don't have actual cost or budget (I need to show in all matrix only thos who have a value in either one actual or budget).
- For the service lines it shows the right value but when I open the service line in the category subline it opens a subline with each existent category for each service, even if a service has only one category both in budget and in actual.
