Forum Discussion
Solution SageWhy do I get Circular Dependancy
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)
Solution SageWell 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....
Resident Rockstarrpinxt, I couldn't reproduce the issue based on the info you provided. Can you share your pbix file with sample data (remove any sensitive data), if possible?
- rpinxt
Could try to do that, but how can one add the pbix file here?
- SivaMani
Upload it to OneDrive or Google Drive and share the URL
- rpinxt
Ok...wel lets see if this works:
https://drive.google.com/file/d/1vFjEX1zQw4xEA2R6gnCWQp1jvyPau54B/view?usp=sharing