difficult and confusing explanation !!
Why visual need to depend on the inactive relationship ? How about visuals for active relationship?
1 answers ( 0 marked as helpful)
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.
Submit an answer
