The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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]
)
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!!
Proud to be a Super User! | |
User | Count |
---|---|
28 | |
11 | |
8 | |
6 | |
5 |
User | Count |
---|---|
35 | |
14 | |
12 | |
9 | |
7 |