Forum Discussion

rpinxt's avatar
rpinxt
Icon for Solution Sage rankSolution Sage
3 years ago
Solved

Why do I get Circular Dependancy

Making calculated columns my first one is this : IF('AVN Rework Merge'[Flow] = "Reworked" && [Amt USD] > -50,[Quantity],0)   It works fine and gives me the quantity that I expected.   Now I want...
Need Help
  • m_alireza's avatar
    m_alireza
    3 years ago

    rpinxt Instead of referencing the measure [FinAmtUSD], try referencing the column directly instead.

    so:

    Reworked USD < 50 = IF('AVN Rework Merge'[Flow] = "Reworked" && 'AVN Rework Merge'[FinAmtUSD] > -50,'AVN Rework Merge'[FinAmtUSD],0)
  • SivaMani's avatar
    SivaMani
    3 years ago

    rpinxt I agree with m_alireza. Also, any specific reason why you went with Calculated Columns instead measures?
    I rewrote the logic as a measure for you. Check if this meets your requirement

    Reworked Qty <50__ = 
VAR Result = CALCULATE(
     [Quantity],
     FILTER('AVN Rework Merge', 'AVN Rework Merge'[Flow] = "Reworked" &&  [Amt USD] > -50)
     )
RETURN
COALESCE(Result,0)
rpinxt's avatar
rpinxt
Icon for Solution Sage rankSolution Sage
3 years ago

SivaMani 

Well yes both logics here are Calculated Columns:

 

Calculated Column 1:

FirstColumn = IF('AVN Rework Merge'[Flow] = "Reworked" && [Amt USD] > -50,[Quantity],0)

 

Calculated Column 2:

SecondColumn = IF('AVN Rework Merge'[Flow] = "Reworked" && [Amt USD] > -50,[Amt USD],0)

 

And yes they are looking at the same columns but column1 returns the Quantity and column2 should return the USD Amount.

 

But as I can see they are not referencing eachother....

SivaMani's avatar
SivaMani
Icon for Resident Rockstar rankResident Rockstar
3 years ago

rpinxt, What about the 'AVN Rework Merge'[FinAmtUSD] and 'AVN Rework Merge'[Flow]? Are they direct columns from the source or calculated in Power BI?

  • rpinxt's avatar
    rpinxt
    Icon for Solution Sage rankSolution Sage
    3 years ago

    FinAmtUSD is directly from the source.

     

    Flow is also directly from the source be it that it comes from an excel file.

    The excel file was merged with the source based on a similar field in both the source and the excel file (FlowKey).

     

    So in base the 2 fields are not calculated.