need help to set below formulla in power bi

[kasai16]

Hi All, 

I am having issues while putting below measure in power BI, it gives me error statting that all types of columns must be from the same table..... however, i have 3 tables which need to be used and have to have 1 measure to be worked using these.... Can someone please help how this will work and not give any error........

Percent of flowCube =
DIVIDE(
CALCULATE(
SUM(

'Table1'[ColumnA]),
ALLEXCEPT(

'Table1',

'Table1'[ColumnB],

'Table1'[ColumnC]),

'Table2[ColumnA],

'Table3'[ColumnA],

'Table3'[ColumnB]
),
CALCULATE(
SUM(

'Table1'[ColumnA]),
ALLEXCEPT(

'Table1',

'Table1'[ColumnC]),

'Table2[ColumnA],

'Table3'[ColumnA],

'Table3'[ColumnB]
)

[rajendraongole1]

Hi @kasai16 - Can you try below measure

Percent of flowCube =
DIVIDE(
CALCULATE(
SUM('Table1'[ColumnA]),
ALLEXCEPT('Table1', 'Table1'[ColumnB], 'Table1'[ColumnC]),
ALL('Table2'[ColumnA]),
ALL('Table3'[ColumnA], 'Table3'[ColumnB])
),
CALCULATE(
SUM('Table1'[ColumnA]),
ALLEXCEPT('Table1', 'Table1'[ColumnC]),
ALL('Table2'[ColumnA]),
ALL('Table3'[ColumnA], 'Table3'[ColumnB])
)
)

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!