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,
So, if it is a hydraulic failure, then the denominator should be utilisation (hours). For any other failure, it should be utilisation (cycles). Am i correct?
Yes, you're correct. Maybe I can create different measures for each type of rate, i.e. 1 hydraulic rate (hours), 1 electric rate (cycles), etc...
My biggest struggle is how to calculate the average of each rate using data slicers for operator, date range an type of failures, since these measures for rates don't exist for months when there are no events (instead of having zeroes in those months). So any average would be incorrect.