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)
SivaMani
Resident Rockstar
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?
rpinxtSolution Sage
Solution SageCould 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