Forum Discussion

Jruiz218's avatar
Jruiz218
Frequent Visitor
6 years ago
Solved

Please Help!!! Grand Total Calculating Wrong Average - Power Pivot

Hello!   Im migrating a report from regular Excel tables/Pivots over to PowerPivot, currently this is my scenario:   In the old version of the report my source data came in the following format: ...
Need Help
  • MFelix's avatar
    MFelix
    6 years ago

    Hi Jruiz218 ,

     

    Based on the data you have send out you need to do the following:

    • Create a measure with the Average of the Hours Handled (this will be used as an intermediat step)
    Measure_Average_Hour_Handle =AVERAGE('Dummy Data'[Hours Handled])
    • Add another measure:
    Average_Hours_Handled =
IF (
    HASONEVALUE ( 'Calendar Resolved'[Date] );
    [Measure_Average_Hour_Handle];
    AVERAGEX (
        SUMMARIZE (
            'Calendar Resolved';
            'Calendar Resolved'[Date];
            'Calendar Resolved'[Week Number]
        );
        [Measure_Average_Hour_Handle]
    )
)

     

    Should work as expected.

sara11's avatar
sara11
Helper I
3 years ago

MFelix 

Hi, I don't know if you could help me with a question that is similar to this one. I want to calculate the average of the difference between two columns (max and min) for the different attempts that I have and that range from 1 to 5, where both the max column and the min column have to be greater than 0. When they aren't, I want it to be blank so it doesn't enter in the average calculation. I've tried different measures, but without success. The average total is always different. Can you help me, please?
I have a dummy table available to help.
Thank you very much in advance.

MFelix's avatar
MFelix
Super User
3 years ago

Hi sara11 ,

 

Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.