Forum Discussion
Circular dependency
Hi Anonymous ,
look at this.
"Nevertheless, by using CALCULATE, we are asking to transform the current row context into a filter context and this modifies the dependency list."
https://www.sqlbi.com/articles/understanding-circular-dependencies/
"Risk Site Level" is therefore part of the filter context of "High Risk".
Hi Anonymous ,
look at this.
"Nevertheless, by using CALCULATE, we are asking to transform the current row context into a filter context and this modifies the dependency list."
https://www.sqlbi.com/articles/understanding-circular-dependencies/
"Risk Site Level" is therefore part of the filter context of "High Risk".
thank you for the article that I read and appreciated a lot. I understood where is the problem
But I don't know why the measures had been working until I changed the table of the calcul of the measures(High Risk).The way of computation and the depency remains the same.
To reduce the list of depency , I tried to use ALLEXCEPT as adviced in the article:
High Risk = IF( CALCULATE(COUNTROWS('SAFE_FINDING'),ALLEXCEPT(vWebSites,vWebSites[name])) = CALCULATE(COUNTROWS('SAFE_FINDING'),LOWER('SAFE_FINDING'[STATUS])="closed",ALLEXCEPT(vWebSites,vWebSites[name])) ,0,1 )I reduced the list of depency to only 1 which is the 'vWebSites'[name] thus the measure 'Risk Site Level' is not anymore part of filter context of High Risk. But nothing change 😞 Have I done something wrong ?
v-lili6-msft Hello, thank you for the answer. I'm not able to send you the PIBX which must be privated
Hi Anonymous,
can you share a screenshot of the Model view?
I have not yet been able to successfully deal with this topic.
hi Anonymous
If possible, could you please use some dummy data to create a sample pbix file for us have a test, that will be a great help.
Regards,
Lin
My data model is still changing so I should adapt my works to it. Currently, I changed my way of computation and it's working.
Thank you very much for your time !
Have a nice weekend !
