Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Circular relationship

Hello,

I´m creating a new Report and need to create a relationship between the Date and Customers tables to calculate de number of Customers whose registration date is equal to the selected date.

 

I can´t create this relationship because this causes a circular relationship.

 

Can you help me to solved this problem?

circular
Date
dependency
  • d_gosbell's avatar
    d_gosbell
    6 years ago

    You should be able to solve this by creating an inactive relationship between the Date and Clientes tables

    Then creating a measure with the USERELATIONSHIP function to activate this relationship for that measure.

    Cliente Registrations = CALCULATE( countrows(Clientes), USERELATIONSHIP(Clientes[Fecha_Alta], Dates[Date]))

    This will allow you to see other measures using the active relationship, but just for the count of client registrations to use the relationship between Clientes and Dates

     

    eg.

     

5 Replies

  • az38's avatar
    az38
    Community Champion
    6 years ago

    Hi Anonymous 

    it depends on full your data model, but try to set Both direction on either Clientes-Date or Cabecera-Date relationships

     

    do not hesitate to give a kudo to useful posts and mark solutions as solution

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi az38 

       

      Thanks for yor answer.

       

      I can't set both directions on the Cabecera-Date relationship because I have different measures in the Cabecera table. Some of these measures use SAMEPERIODLASTYEAR.

      • az38's avatar
        az38
        Community Champion
        6 years ago

        Anonymous 

        that's what i mean: for help show please your data model (example of data, measures and point where the error appears)

         

        do not hesitate to give a kudo to useful posts and mark solutions as solution