Calculated Columns Affected By Slicer Filters

Thank you for taking the time to provide this sample. However, it still does not acheive the desired results. If you look at the failure counts in the table you see that the overall failure rate is what the failure rate column is telling you but when you look at the graph you can see that the overall rate is given to two different failure modes. What I would expect is that the two failure modes for that day would show their individual failure rate. For instance, on May 04 there was a total of 4 failure counts - 1 for mode1 and 3 for mode3. The total runs for that day was 6 so for mode1 the failure rate should be 1/6 and for mode2 it should be 3/6. These two failure rates make up the 66.67% that is shown for both of these modes on the graph.