The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello
this is my model:
I need to get one field from table A and show the related fields in tables B and C use the inactive relationship between them.
for example, i need the
A.project_name B.Request_Number C.Reference_Bil
can I do it without changing the relationships?
I tried to do it with calculate max and userelationship but i need to get all the related values and not only the max/min.
Solved! Go to Solution.
I know, this is what the measure allows if you use the measure in combination with columns from two different tables connected by an inactive relationship:
Maybe this makes it clearer.
Just select the columns from the different tables.
But maybe I did not understand what you are looking for.
Regards,
Tom
Thank you, but its not what i mean..
i need it to return the value and not the count of the values.
I know, this is what the measure allows if you use the measure in combination with columns from two different tables connected by an inactive relationship:
Maybe this makes it clearer.
Just select the columns from the different tables.
But maybe I did not understand what you are looking for.
Regards,
Tom
It works, Thank you very much.
Hey @Anonymous ,
basically it's not possible to activate an inactive relationship without a calculation. The reason for this is - USERELATIONSHIP is considered being a filter modifier function. This means you need CALCULATE or CALCULATETABLE to use USERELATIONSHIP.
Assuming I have two tables connected by an inactive relationship I create a measure like this:
Check Relationship Product / ProductSubcategory =
CALCULATE(
COUNT( 'DimProduct'[ProductName] )
, USERELATIONSHIP( 'DimProductSubcategory'[ProductSubcategoryKey] , 'DimProduct'[ProductSubcategoryKey] )
)
The implicit NULL filter in a table or matrix visual provides the expected result.
Because there are three tables involved you might also use some visual level filtering.
Hopefully, this provides some ideas on how to tackle your challenge.
Regards,
Tom
User | Count |
---|---|
75 | |
70 | |
40 | |
30 | |
28 |
User | Count |
---|---|
104 | |
95 | |
51 | |
50 | |
46 |