Forum Discussion
Solved
Relationship 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?
Thanks you danextian
The combination of calculate, userelationship, and crossfilter produced the output I was after 😉