Forum Discussion
Helper IRelationship Error When using Measure moved from one table to another
Super Usersoni27 , Can you tell us the formula and error. Measure belong to the model. So not sure what do mean by moving from one table to another
soni27in POWER Pivot Model: I have created in the measure grid in MDRISSUED Table:
Submit Actual New issued:=CALCULATE(DISTINCTCOUNT(MDRISSUED[NS_DOCUMENT_NO])), when I use it in Pivot table there is no error.When I moved it to another table or cut copy paste another table MDRPLANNED; there is Error
"Relationship bwtween tables may be required"
please assist
- amitchandak
soni27 If you want to use measure across the table. Assume you have type in table 2 and you want plot you measure on that. They need to have a relation for the correct result.
- soni27
Power Poviot:
Fact Table 1 : Have two DimentionsFact Table 2: Have Three Dimentions:
When my measure rests in Tabel 2 ;There is no error but when I move to table 1; It is gives error; I thought we can keep my mesaure in any table since it belongs to Data Model and same you as explaiend in your earlier post.
Please explain do we need to have the same dimentions for both Fact tables ?