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 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!!!