Data Modeling

[Anonymous]

Hello Allo,

I need your advice for designing a data model

Today I have a model like this:

Is there a way to have the Dimbrand dimension filtering the DimQuestion dimension ? 

Thank you for your help 

[TeigeGao · Accepted solution]

Hi @Anonymous ,

In your scenario, we can use the USERELATIONSHIP() function to specify the relationship to be used in a specific calculation as the one that exists between columnName1 and columnName2.

We can use this function in the column Dimbrand dimension and DimQuestion dimension.

Best Regards,

Teige