Forum Discussion
Active and Inactive Relationship - Display Chart on Inactive Relationship
Hi JustDavid
Thanks for the reply from lbendlin .
Is the following result you want? If so, please refer to the measure below and the attachment.
Total Amount by Start Date = VAR Startdate = CALCULATETABLE( VALUES(tblLots_by_CloseDate[Start Date]), ALL(tblLots_by_CloseDate), 'tblLots_by_CloseDate'[Close Date] = MAX('tblLots_by_CloseDate'[Close Date]) ) RETURN CALCULATE( SUM(tblProforma_Indexing[Amount]), ALL(tblProforma_Indexing), 'tblProforma_Indexing'[Date] IN Startdate )In my test, there is no active relationship between several tables. If there are still problems, please feel free to let me know.
Best Regards,
Yulia XuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Isn't that what I currently am doing (except the bridge table)?
I have a calendar dimension table (tblDate), and 2 fact tables (tblLots_by_CloseDate and tblProforma_Indexing).
The reason why I need the bridge table is so that when I filter on Product Type (which comes from tblLots_by_CloseDate), I need it to return the result that's on tblProforma_Indexing). Without the bridge table, it won't gets filtered at all.
Assume like you said, I ditch the bridge table, HOW do I make a relationship from tblLots_by_CloseDate and tblProforma_Indexing between the close date in tblLots_by_CloseDate and start date in tblProforma_Indexing?
Hi JustDavid
Thanks for the reply from lbendlin .
Is the following result you want? If so, please refer to the measure below and the attachment.
Total Amount by Start Date =
VAR Startdate =
CALCULATETABLE(
VALUES(tblLots_by_CloseDate[Start Date]),
ALL(tblLots_by_CloseDate),
'tblLots_by_CloseDate'[Close Date] = MAX('tblLots_by_CloseDate'[Close Date])
)
RETURN
CALCULATE(
SUM(tblProforma_Indexing[Amount]),
ALL(tblProforma_Indexing),
'tblProforma_Indexing'[Date] IN Startdate
)
In my test, there is no active relationship between several tables. If there are still problems, please feel free to let me know.
Best Regards,
Yulia Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.