USERELATIONSHIP on an inactivated relation

[Paul_Kuntz]

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 inactive relationshipThe error

[Icey]

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]

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])))

[Paul_Kuntz · 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 ?

[amitchandak]

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