Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Paul_Kuntz
New Member

USERELATIONSHIP on an inactivated relation

Hi all,

 

I created the attached model to highlight my problem.
In the tkt table I try to calculate the creation date of the corresponding company.
I have created the creation column which only works when I activate the relationship between the account column of the company table and the company column of the tkt table.

The use of userelationship does not work when this relationship is not active.
It seemed to me that its purpose was precisely to get rid of it.

Hope you'll be fine with my french version.
Thank you for your help.

The tablesThe tablesThe inactive relationshipThe inactive relationshipThe errorThe error

 

1 ACCEPTED SOLUTION

Thank you, it's working with "new column = maxx(filter(company,tkt[entreprise] = company[account]),company[creation])" to get the date of creation of the enterprise.

 

Any idea why USERELATIONSHIP is'nt working ?

 

View solution in original post

4 REPLIES 4
Icey
Community Support
Community Support

Hi @Paul_Kuntz ,

 

If @amitchandak has solved your problem, please accept his reply as a solution so that people who may have the same question can get the solution directly.

 

 

Best Regards,

Icey

amitchandak
Super User
Super User

You are creating a new column to bring what?

You can do that like this

new column = maxx(filter(company,tkt[enterpise] = company[company]),company[ref])

 

Ideally, the date to the company join should be inactive

Or create a common dim

company = distinct(union(all(tkt[enterpise]),all(company[company])))

Thank you, it's working with "new column = maxx(filter(company,tkt[entreprise] = company[account]),company[creation])" to get the date of creation of the enterprise.

 

Any idea why USERELATIONSHIP is'nt working ?

 

Also, use crossfilter to remove the other join.

userelation to add the one relation and cross filter to remove the other.

Add company and remove the date . remove can be done for another table not only for this table.

You have to make sure there are no two paths

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.