Forum Discussion
Rate between tables
Yes I agree. That's why I tried to insert columns in the Utilization data table to count the number of events from the event data, however PowerBi wouldn't let me insert more than one calculated column in the Utilization data table (circular dependency error). I would need three columns for counting the three different kinds of failures for each month.
After searching in other blogs, I found this comment for a similar issue:
"Power BI does not allow to have two calculated columns that contain measures that are also based on that table. In order to understand why, you'd need a better understanding of what's going on under the hood. In order to get around it, you should try turning these into measures".
So it looks like I would need to create measures to count the number of events. Any idea how?
Thanks!
Hi,
Without that coolumn, i dno't think we can solve this problem. We just need that one column and think we will be sorted. Also, i don't think that will be a caculated column - that will be an input which has to come straight from the user or from your system where you imported this data from.
- 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,
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.