Forum Discussion
Circular Dependency Issue
jmnigrelli , 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.
amitchandak thank you for your response, this unfortunately did not work.
This is basically what I am working with
| Process | Machine | Failure Mode A | Failure Mode B | Failure Mode C |
| Process 1 | Machine A | 0 | 1 | 1 |
| Process 2 | Machine A | 0 | 0 | 2 |
| Process 1 | Machine A | 0 | 2 | 0 |
| Process 2 | Machine B | 1 | 3 | 3 |
| Process 1 | Machine B | 2 | 1 | 2 |
| Process 2 | Machine B | 0 | 2 | 1 |
Process 1 | Machine B | 1 | 0 | 0 |
| Process 2 | Machine B | 0 | 1 | 1 |
| Process 1 | Machine B | 1 | 0 | 1 |
The way I have it set up now, is:
Column, Total Failures = ('Data Set[Failure Mode A]+[Failure Mode B]+[Failure Mode C])
Measure, Total Count = (Countrows('Data Set'))
Column % Total Failures = ([Total Failures]/(([Total Records])*45)*100)
And then I have a filter on the page only looking at process 1 (process 1 needs to be multiplied by 45)
The above gives me exactly what I need!
For process 2, the total records needs to be multiplied by 200, this is when I run into issues with the circular dependency. Does this help?
Thank you!!!