topic How to identify and clear a circular dependency? in DAX Commands and Tips

How to identify and clear a circular dependency?

unknown917 — Tue, 24 Sep 2024 11:05:41 GMT

I have a column I am trying to formulate and I get a circular dependency error on Calculated Column 'B' :

Column = SWITCH(

TRUE(),

'Table 1'[A] = "Y",0,

'Table 1'[B] = "%BANANA%" && 'Table 1'[B]<2,2,

'Table 1'[B] = "%CUCUMBER%" && 'Table 1'[B]<1,1

BLANK()

)

The calculateD column it is referencing is:

B = SWITCH (

TRUE(),

[C]= 1 && ABS([D]) <= .70, [E],

[C]= 1 && ABS([D]) > .70, MIN(208, MAX([E], [E])),

[F] < .10, 3,

[F] < .10, 2,

[F] < .10, 1,

ABS([D]) <= .70, [E],

ABS([D]) > .70, MAX([E], [E))

A,C,D,E,F are all measures. If the dependency is 'B', how do I clear it?

Re: How to identify and clear a circular dependency?

lbendlin — Mon, 23 Sep 2024 20:58:03 GMT

You cannot (should not) calculated columns from measures. There's no filter context.

You can avoid circular references by pushing the calculation up into Power Query.

Re: How to identify and clear a circular dependency?

unknown917 — Tue, 24 Sep 2024 11:07:51 GMT

unfortunately not possible due to need for manual input by the end user. I've seen some articles referencing using filter in the calculated column to remedy, but not sure I understand how it works for my instance?

Re: How to identify and clear a circular dependency?

lbendlin — Tue, 24 Sep 2024 12:00:06 GMT

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Re: How to identify and clear a circular dependency?

unknown917 — Tue, 24 Sep 2024 19:36:00 GMT

When I formulated B as a measure and attempted to use it in simple table visual, I get the "exceeded the available resources" message.

Re: How to identify and clear a circular dependency?

lbendlin — Tue, 24 Sep 2024 19:40:25 GMT

Final request: Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523