Forum Discussion
DataNinja777
Super User
Super UserRelationship issue
Hi Power BI Community, I have a following data model where I have two chart of accounts of different companies mapped by connecting key. I'd like to see the G/L Account of Company A side by sid...
Hi DataNinja777,
You cannot use an inactive relationship to filter table A from a column in table B like you can with an active relationship. You need to use USERELATIONSHIP to invoke such a relationship in a measure and put that measure in your visual.
= CALCULATE ( SUM ( tableB[Column] ), USERELATIONSHIP ( tableA[key], tableB[key] ) )But I'm curious, since you have a related table in between thet two fact tables, why not use that instead?
danextianSuper User
Super UserHi DataNinja777,
You cannot use an inactive relationship to filter table A from a column in table B like you can with an active relationship. You need to use USERELATIONSHIP to invoke such a relationship in a measure and put that measure in your visual.
=
CALCULATE (
SUM ( tableB[Column] ),
USERELATIONSHIP ( tableA[key], tableB[key] )
)
But I'm curious, since you have a related table in between thet two fact tables, why not use that instead?