The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello
I have 2 tables (tableA and tableB) related with inactive relationship. I want to create a flag measure that activate the relationship between tables.
I want to be able to chose an attribute from one table and see relataed attribute from the other table.
I begin with doing this measure and I want to know if it is the better solution :
PS : tableA is the many side of the relation
CALCULATE(
SUMX('tableA', 1),
USERELATIONSHIP('tableA'[FkI_tableB], 'tableB'[ID_tableB])
)
Read about TREATAS - much simpler to use and doesn't require any relationships.
User | Count |
---|---|
18 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
28 | |
13 | |
12 | |
9 | |
8 |