Forum Discussion
% Difference from the previous quarter
the problem is (and its difficult to tell without access to your model) but to me it looks like its going via the target table, it should be directly linked, your report table should be directly linked to date in a one to many relationship to your calendar
ie active relationship one to many from calendar to report, I can't see the relationship in your model pic above.
otherwise please supply your model so one can see what is going on.
vanessafvg this is my full data model. The targetID is connected to the Report table, so the calendar target and report tables should all be linked no?
This is actually difficult to help you with such limited information.
What is the meaning of linking target to report? I will need to understand the business objective of what you are trying to do here.
The issue here and the error you are getting is that it is unable to return a single value for your measure which means your relationships between your tables are returning multiple rows rather than just one value, which in the case of a measure, it requires one value.
This problem almost always lies in how the data is modelled.
You will need to explain what you are actually trying to do, i think more business context is required here.
I personally would never link it that way;
calendar should be connect to report separately
calendar should be connected to target separately
but without understanding what you are trying to measure, and why target sits in the middle the technical only information only you have provided isn't enough to help you solve this problem.
hope that makes sense.