Forum Discussion
Rate between tables
Hello! I'm quite new to PBI and I'm trying to resolve this issue. It'd be great if any of you could help. I have two tables setup as below, and I need to create a visual to show the failure rate acc...
Hi Ashish,
Just to clarify, what do you mean by having types of failures in Table 2? What is it that you want to add on Table 2 as a column? Bear in mind there are 3 types of failures which can happen in the same month, and multiple times per month.
Thank you.
Hi.
On Table 2, there should be a column for type of failures (the same one that you have in Table 1).
- I have been trying to do that for one type of failure to begin with. Unfortunately as I said before I can only create one calculated column to count the sum of one type of failure every month in Table 2. If I then try to create a second calculated column to count the second type of failure, or to simply calculate the rate of the first column divided by the total monthly hours, there is an error in PBI about "circular dependency detected". I can't create more than one calculated column apparently.