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,

 

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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago
      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!
      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        8 years ago

        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.