Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
kasai16
Regular Visitor

need help to set below formulla in power bi

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

1 REPLY 1
rajendraongole1
Super User
Super User

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.