Forum Discussion

Dayna's avatar
Dayna
Helper V
7 years ago
Solved

Cyclic relationship on table structure

Hi All,   I have two database tables: Server and Test Log   In the server table, I store some basic information about the server, for example, the date it was issued, the name, etc...   In the...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    7 years ago

    Hi Dayna,

     

    Sorry for late, I have reproduced your issue like below. For example, if you create a slicer based on one column in MasterCalendar table and select a value to filter DR TestingLog. There're two kinds of filter route, one is MasterCalendar-> DR TestingLog, another is MasterCalendar-> DR Server-> DR TestingLog. So there may be two different filter results in DR TestingLog which may cause ambiguity. 

      

     

    Regards,

    Jimmy Tao

     

Dayna's avatar
Dayna
Helper V
7 years ago

Hi Jimmy,

 

Tried it - but still unable to make the relationship active. I've included a screenshot of the updated ERD:

v-yuta-msft's avatar
v-yuta-msft
Community Support
7 years ago

Hi Dayna,

 

Sorry for late, I have reproduced your issue like below. For example, if you create a slicer based on one column in MasterCalendar table and select a value to filter DR TestingLog. There're two kinds of filter route, one is MasterCalendar-> DR TestingLog, another is MasterCalendar-> DR Server-> DR TestingLog. So there may be two different filter results in DR TestingLog which may cause ambiguity. 

  

 

Regards,

Jimmy Tao

 

  • Dayna's avatar
    Dayna
    Helper V
    7 years ago

    Hi Jimmy,

     

    That makes sense, and thank you for your help. It's much appreciated!

     

    All the best,

    Dayna