need help to set below formulla in power bi

kasai16 — Tue, 09 Jul 2024 12:16:45 GMT

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]
)

Re: need help to set below formulla in power bi

rajendraongole1 — Tue, 09 Jul 2024 12:29:29 GMT

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!!

topic need help to set below formulla in power bi in DAX Commands and Tips

need help to set below formulla in power bi

Re: need help to set below formulla in power bi