Forum Discussion
Rate between tables
Hi Dale,
I've uploaded a dummy file here. My end goal is to have a gauge where if I select a data range, operator and type of failure the value will be the average of the rates for all the months. included in the data range I selected. At the moment the value shown by the gauge is simply the sum of the rates, and not the average. As I understand it, there are currently 2 issues:
1- value is a total and not the average of the monthly rates
2- even if the value was an average, since the Rate measure doesn't return any value for months where there were no failure events, the average would be wrong. I need Rate measure to return "0" every month when there are no failure events.
Thank you!
Hi,
Please share the download link of the Excel file where you have all Tables.
Hi,
I think the missing piece of information here is the Failure type column in the Utilisation Data table. Unless we have that column in that table, we would not know which rows have to be summed up from the utilisation data table.
- Ashish_Mathur
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!