How to identify and clear a circular dependency?

[unknown917]

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?  

[lbendlin]

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.

[unknown917]

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?

[lbendlin]

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

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

[unknown917]

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

[lbendlin]

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

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