Forum Discussion
rpinxt
Solution Sage
Solution SageWhy 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...
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 requirementReworked Qty <50__ = VAR Result = CALCULATE( [Quantity], FILTER('AVN Rework Merge', 'AVN Rework Merge'[Flow] = "Reworked" && [Amt USD] > -50) ) RETURN COALESCE(Result,0)
rpinxtSolution Sage
Solution SageThe Amt USD measure refers to a field from the table like :
Amt USD = SUM('AVN Rework Merge'[FinAmtUSD])
