How to use sumx with non-related tables

[ngocnguyen]

Hi

I have a Model as below: I wanna create a matrix that getting from Table Dim_PL_Layout the column Level 2 and a Amount column with below logic:

For each row in Fact_PL table, let multiple the Actual column in Fact_PL with Column Value in PL_Calculation_table:

I wrote a Formulas like 

= SUMX(Fact_PL,Fact_PL[Actual]* RELATED(PL_Calculation_table[Value])

However, it not work. Maybe due to the relationship between Fact_PL and PL_Calculation_table is Many-Many

So, is there any way to do it?

[andhiii079845]

I create this little example:

If you choose level = 2 -> Details B and C are in focus and you really want than the sum auf Actual of B and C? 

[ngocnguyen]

@andhiii079845 

Thanks you for your reply

Maybe My question is not really clear. So, let me take a screen shoot as belows:
Table 1 and Table 2 will be in data model

Result is what I expect to get. For each data,  Level 2, it will go to each row in Details column of Table 1. Then get the Value column, then multiple it with Actual column in Table 2. After that, get the Sum of them

[andhiii079845]

You talking now about 2 tables, before about 3 tables. Please show us a example with the 3 tables. Upload the xlsx via a external upload service. I think with this information it is not 100 % clear what you want 🙂 

[andhiii079845]

Do you have a pbix file with some data example data ?