Forum Discussion

GRN_VPR8's avatar
GRN_VPR8
Frequent Visitor
2 years ago
Solved

Average

I'm hoping someone can assist, but I seem to be lost. I have been looking at AVERAGE & AVERAGEX commands and various other posts and just seem to be able to get the desired result. The challenge I...
  • OwenAuger's avatar
    OwenAuger
    2 years ago

    GRN_VPR8 

    Can you compare the attached PBIX against your version?

     

    The measure values in a matrix appear to match the summary table in your first post, where each individual date shows a sum, and those sums are averaged in the AVG column.

     

    I made a slight adjustment in the attached PBIX to make use of a Date table, with some alternatives shown commented:

    Average of Daily Sum of Duration = 
AVERAGEX (
    VALUES ( 'Date'[Date] ),
    -- Alternatives:
    -- SUMMARIZE ( Data, 'Date'[Date] ),
    -- VALUES ( Data[DATE] ),
    CALCULATE ( SUM ( Data[DURATION] ) )
)

     

    Regards

GRN_VPR8's avatar
GRN_VPR8
Frequent Visitor
2 years ago

Thanks for replying. I tried that, and all I got was an identical sum of duration for the day, not the average I was looking for.

OwenAuger's avatar
OwenAuger
Super User
2 years ago

GRN_VPR8 

Can you compare the attached PBIX against your version?

 

The measure values in a matrix appear to match the summary table in your first post, where each individual date shows a sum, and those sums are averaged in the AVG column.

 

I made a slight adjustment in the attached PBIX to make use of a Date table, with some alternatives shown commented:

Average of Daily Sum of Duration = 
AVERAGEX (
    VALUES ( 'Date'[Date] ),
    -- Alternatives:
    -- SUMMARIZE ( Data, 'Date'[Date] ),
    -- VALUES ( Data[DATE] ),
    CALCULATE ( SUM ( Data[DURATION] ) )
)

 

Regards

  • GRN_VPR8's avatar
    GRN_VPR8
    Frequent Visitor
    2 years ago
    Thank you for figuring it out!