Help with circular dependency !!

[apcor]

Hi,

I have created the following relational model to present a dashboard with Service Level indicators for a given week, the main tables are RQPax (transport orders and their planned date for execution), ServEjec (detail of the transport orders executed and their date of execution), Check In (detail of the states of the transport orders in each day of the week) and the Dates table (the dates corresponding to the current week)

I have created the ReSchedLDATE measure that calculates the transport orders rescheduled with respect to a certain planning date, for example if for Tuesday I have 20 quotas planned to be executed and in 5 of these they are rescheduled to be executed at a later date and 10 were executed on Monday, the measure would return 15:

ReSchedLDATE = CALCULATE(COUNTA('Check In'[CÓDIGO DE CUPO]), USERELATIONSHIP('Check In'[Fecha Actual], Fechas[Fecha]), FILTER(ALL(EstatusSecund), EstatusSecund[Status] IN {"Reprogramado"}), FILTER(RQPax, RQPax[FECHA]))+CALCULATE(COUNTA('Check In'[CÓDIGO DE CUPO]), USERELATIONSHIP(Fechas[Fecha], 'Check In'[Fecha Actual]), FILTER(ALL(EstatusSecund), EstatusSecund[Status] IN {"Ejecutado"}), FILTER(ALL(Observacion), Observacion[Observación] <> "NA"), FILTER(RQPax, RQPax[FECHA]))+0

I also have the "CancelDiario" measure that calculates the number of quotas canceled with respect to a certain planning date:

CancelDiario = CALCULATE(COUNTA('Check In'[CÓDIGO DE CUPO]), USERELATIONSHIP('Check In'[Fecha Actual], Fechas[Fecha]), FILTER(ALL(EstatusSecund), EstatusSecund[Status] IN {"Cancelado CH"}), FILTER(RQPax, RQPax[FECHA]))+0

My ultimate goal is to create a waterfall chart and to do this create the "Cascada" table. I started by creating a table where I would create calculated columns with the measurements that I want to go on the graph but I ran into this problem:

By adding NetReprog computed column to "Cascada" table with measure "ReSchedLDATE" (apply an if to make it 0 when column "Factores" equals "Ejeuctado" and measure "ReSchedLDATE" otherwise) and then add column "Cancelados" with the "CancelDiario" measure tells me that a circular dependency was detected.

Maybe I'm making a basic mistake but can't fix it, I would really appreciate your support.

I attach the file for further analysis, thanks

https://1drv.ms/u/s!ApCMMsojeP2hm1im3bXfqpwECiyH?e=amdRul

[amitchandak]

@apcor , refer if this can help

https://www.sqlbi.com/articles/avoiding-circular-dependency-errors-in-dax/