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...
Ashish_Mathur
Hi! Unfortunately the values in that column don't come form the input fle, and cannot be entered by the user as we're talking about hundreds of data points.
Those values (total events for each month) needs to be calculated from the event data. The event data table gives you one line for each event. We need to create a measure that calculates the total number of events for each month, each customer, each type of asset and each failure mode.
Thank you.
Hi! Unfortunately the values in that column don't come form the input fle, and cannot be entered by the user as we're talking about hundreds of data points.
Those values (total events for each month) needs to be calculated from the event data. The event data table gives you one line for each event. We need to create a measure that calculates the total number of events for each month, each customer, each type of asset and each failure mode.
Thank you.
Hi,
Calculating the number of events is not a problem because that is a simple count rows operation from Table1. The problem is calculating the ratio because the denominator has to come from Table2. So unless we have type of Failure in Table2, we will not be able to compute the denominator.
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.