Forum Discussion
Relationship Error When using Measure moved from one table to another
When a measure is moving from one Table to another Table it gives Relationship Error.
First I Made the following measure in MDRISSUED Table, there is no error:
=CALCULATE(DISTINCTCOUNT(MDRISSUED[NS_DOCUMENT_NO]))
There is no error
When I move to another Table MDRPLANNED it gives Relationship Error.
Please explain how to address
6 Replies
soni27 , 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
in 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
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.
