Forum Discussion

nanma94's avatar
nanma94
Helper III
9 years ago
Solved

Data model loop: cant point 2 transaction dates to DateTable

On a high level, I have the requirement to show customers sales, and customer interaction (sales initiated activities) count, and whether customer interaction (activity count) is relate to driving re...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi nanma94,

    You got the ambiguity warning when making the relationship between the DateTable and Event tables active, right? If so, assume that you are allowed to make the relationship active, in this case, you create an ambiguous path from DateTable to Account, should DateTable traverses Sales Plan Monthly or Event?

    In your scenario, you can set cross filter direction of relationship between Account and Event from “Both” to “Single” , that way, you will be allowed to make the relationship between the DateTable and Event tables active.


    Or as other post, keep the relationship between the DateTable and Event tables inactive, and you can use USERELATIONSHIP function to override the active relationship when utilizing DAX.

    Thanks,
    Lydia Zhang

nanma94's avatar
nanma94
Helper III
9 years ago

Thanks much Bhavesh for your reply. Its definitely relevent but still doesnt solve my issue directly:(

 

I really need both sales table and event table to point to date table in order to allow a date slicer to drive both to change. Though the white paper points out better not have relationship to a date table bidirectional...

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi nanma94,

You got the ambiguity warning when making the relationship between the DateTable and Event tables active, right? If so, assume that you are allowed to make the relationship active, in this case, you create an ambiguous path from DateTable to Account, should DateTable traverses Sales Plan Monthly or Event?

In your scenario, you can set cross filter direction of relationship between Account and Event from “Both” to “Single” , that way, you will be allowed to make the relationship between the DateTable and Event tables active.


Or as other post, keep the relationship between the DateTable and Event tables inactive, and you can use USERELATIONSHIP function to override the active relationship when utilizing DAX.

Thanks,
Lydia Zhang