Forum Discussion

RookiePBI2019's avatar
RookiePBI2019
Regular Visitor
7 years ago
Solved

Sum average by Date

Hi all,   I would need some help with a specific DAX formula that it is getting me crazy. I need the sum of average by date and WH of the following table:   Date WH Total Lines 13/05/201...
Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    RookiePBI2019 here is the measure for you

     

    Sum of Avg by Date and WH = 
SUMX( 
SUMMARIZE( Table1, Table1[Date], Table1[WH] ),
 CALCULATE( AVERAGE( Table1[Total Lines] ) ) 
)
parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

RookiePBI2019 here is the measure for you

 

Sum of Avg by Date and WH = 
SUMX( 
SUMMARIZE( Table1, Table1[Date], Table1[WH] ),
 CALCULATE( AVERAGE( Table1[Total Lines] ) ) 
)
RookiePBI2019's avatar
RookiePBI2019
Regular Visitor
7 years ago

Thank you so much! It works perfectly!