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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

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
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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