Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

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?

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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!

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 years ago

    Hi,

     

    Please share the download link of the Excel file where you have all Tables.

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Ashish_Mathur

       

      Here is the Excel file. Thanks!

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        8 years ago

        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.