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.  ...
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.