Measure to calculate Average

Hi dataanalyst2023 ,

Depending on the information you have provided, you can follow these steps below:

1.Merge Queries.

2.Add new columns.

Actual Rate =
VAR _AverageActual =
    AVERAGE ( 'Table 1'[Average Actual Index] )
VAR _WeekIncidentCount = 'Table 1'[Table 2_5 week Incident Count] / 1000
VAR _WeekHours = 200000 / 'Table 1'[Table 2_5 Week worked Hours]
RETURN
    _AverageActual * _WeekIncidentCount * _WeekHours

Potential Rate =
VAR _AveragePotential =
    AVERAGE ( 'Table 1'[Average Potential Index] )
VAR _WeekIncidentCount = 'Table 1'[Table 2_5 week Incident Count] / 1000
VAR _WeekHours = 200000 / 'Table 1'[Table 2_5 Week worked Hours]
RETURN
    _AveragePotential * _WeekIncidentCount * _WeekHours

Final output:

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi dataanalyst2023 ,

You can certainly add multiplication between two lines, and you can check out the documentation below to see how the VAR function is used, which can help you understand it better:
Use variables to improve your DAX formulas - DAX | Microsoft Learn

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.