active and inactive
I dont get it. How does active relationship between date key abd DueDateKey can affect the graph sum of sales amount. They are not related at all.
Exactly, inactive relationships do not work unless you use DAX formula USERELATIONSHIP. Two tables can only have one active relationship between them and as many inactive as you want. Inactive relationships are marked with dotted line between the tables and they can only produce results if you write a DAX calculation using CALCULATE or SUMX functions and specify in the filtering that you need to use USERELATIONSHIP and mention what key from table A will connect to what key from table B in order to produce a result.