DAX Measure for Calculating Average value per hour

[Ibrahim_shaik]

Hello Power BI Community,

I Have Created a DAX to column to Calculate the Average Consumption Value Per Hour.

I have 5 Minute interval Data from that I created the hour column and from the Hour Column I have created the measure.

But When the use the measure in Table visual and Card it shows different Values.

Why is it so?

Here is the DAX below

Average_Cal_tot_hvac_b35_PerHour =

AVERAGEX(

    SUMMARIZE(

        'INNOTECH HVAC',

        'INNOTECH HVAC'[Hour_Data],  -- Extract the hour from the timestamp

        "AverageConsumption", AVERAGE('INNOTECH HVAC'[Cal_tot_hvac_b35])

    ),

    [AverageConsumption]

)

[Ibrahim_shaik]

Hi @lbendlin ,

Thank you for the response.

The Values are Equal on Both the Visuals now.

[lbendlin · Accepted solution]

Check the filter icon for both visuals, make sure they are impacted by the same set of filters.