Add rows to table when merge and no coincidence

Hello community!

I am trying to add rows if there is no coincidence, like this:

Table 1:

CompanyCode (if it is null or text "All" add as many rows as companies are in table 2)

Account

CompanyCode-Account

Table 2:

CompanyCode

CompanyDescription

Table 3 data:

CompanyCode

Account

Amount

CompanyCode-Account (connect to table 1)

I want to classify wiht the table 1 data in table 3. For example;: in table 1 it appears companycode 1 and account 57 and description "Bank". Then I would have 1-57 and Bank. If there is no company code I would have all the companycodes (for example from 1 to 50) and account 57 and description bank.

Could you help me? Thank you very much in advance. I am trying to make my way in pbi.