Related

Anonymous 

You can create a virtual relaionship bewteen two unrelated tables using the TREATAS function as the filter expressions. For example, say you had  two unrelated tables:
Table 1

Table 2

You could create the following measures:

1)

Sum of sales = SUM(Table2[Sales])

2) 

Sum of Forecast = SUM(Table1[Forecast])

3) 

Sales (TREATAS) = CALCULATE([Sum of Sales], 
          TREATAS(VALUES(Table1[Country ID]), Table2[Country ID))

Then create a visual using the field Table1[Country ID] and the [Sum of Forecast] and [Sales (TREATAS)] and both would be filtered by the Country ID.

Make sense?

Anonymous , Why the relationship is inactive?

You can activate it using userelationship  https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in-power-bi

related need active relation

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Hi  Anonymous ,

According to your description, I created two unrelated tables:

Here are the steps you can follow：

1. Create calculated column. Use the relatedtable function in table2 to calculate the amount in the table

Column = SUMX(RELATEDTABLE('Table'),'Table'[amount])

2. Result

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.