calculations with bridge table

[Pbiuserr]

Hello

I have bridge table as on screenshot. I try to make calculated column in main table which includes DIVIDE (table1[column], table2[column],0) and measure Measure = DIVIDE (SUM(Table1[Column]), SUM(Table2[Column]),0 )

Is that possible?

[v-yangliu-msft · Accepted solution]

Hi  @Pbiuserr ,

I created some data:

Table1：

Table2：

Table3：

There can only be one active relationship in the data model between two tables, even if you add another relationship, it is inactive

If you want to activate this inactive relationship, you must close another active relationship. Active relationships are represented by solid lines, and inactive relationships are represented by dashed lines.

Here are the steps you can follow：

1. Create calculated column.

Column =
DIVIDE(
CALCULATE(SUM('Table'[Amount]),FILTER(ALL('Table'),'Table'[date]=
MAXX(FILTER(ALL('Table3'),'Table3'[Group]=EARLIER('Table2'[Group])),[date]))),
'Table2'[Amount2])

2. Create measure.

Measure =
DIVIDE(
SUM('Table'[Amount]),SUM('Table2'[Amount2]))

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

[amitchandak]

@Pbiuserr , Table1 and table2 is not having any common table/dimension as per the diagram shared. You can we this measure only at grand total level

DIVIDE (SUM(Table1[Column]), SUM(Table2[Column]),0 )

[Pbiuserr]

Is there any way to calculate it as column in the main table (for example create a bridge between table 1 and table 2) ?