Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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 |
---|---|
12 | |
12 | |
8 | |
8 | |
6 |
User | Count |
---|---|
27 | |
19 | |
14 | |
11 | |
7 |