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".
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
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 !
Hi Anonymous,
Please mark a post as solution, this will also help others.
Please give Kudos for support.