Forum Discussion
Circular Dependency Issue
I have a column to calculate % Failures by taking a column I created to sum failures, and a measure I used to count rows. I need to multiply one % failures by 45 and another % failures by 200, as th...
amitchandak
Super User
Super Userjmnigrelli , Assuming Total failures and Total count are measures
that this should work
% Failures = Divide([Total failures], [Total count]*200)*100
https://www.sqlbi.com/articles/avoiding-circular-dependency-errors-in-dax/
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.