Forum Discussion

Ibrahim_shaik's avatar
Ibrahim_shaik
Icon for Helper V rankHelper V
2 years ago
Solved

DAX Measure Shows Different Value in Table Visual and Card Visual

Hello Power BI Community,

 

I Have Created a DAX a 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 i use the measure in Table visual and Card visual 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]
)
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Ibrahim_shaik ,

    Based on the information you provided, the discrepancy appears to be due to each visual interpreting and aggregating the data in a different way. Here are the reasons for the discrepancies:

    1. When you use a Measure in a Table visual, the value may be grouped by hour (or other dimension present in the table). This means that the average consumption per hour will be calculated and displayed for each hour or group present in the visual.
    2. The Card visual object displays individual values. When using a Measure in a Card visual, it essentially calculates the average consumption for all hours or for the entire dataset, not for each individual hour.

    To work around this issue, make sure that the context of the filters applied to the Table and the Card visual are consistent. Differences in filters and slicers may result in different values being calculated.

     

    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.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Ibrahim_shaik ,

    Based on the information you provided, the discrepancy appears to be due to each visual interpreting and aggregating the data in a different way. Here are the reasons for the discrepancies:

    1. When you use a Measure in a Table visual, the value may be grouped by hour (or other dimension present in the table). This means that the average consumption per hour will be calculated and displayed for each hour or group present in the visual.
    2. The Card visual object displays individual values. When using a Measure in a Card visual, it essentially calculates the average consumption for all hours or for the entire dataset, not for each individual hour.

    To work around this issue, make sure that the context of the filters applied to the Table and the Card visual are consistent. Differences in filters and slicers may result in different values being calculated.

     

    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.