Forum Discussion

Jamey's avatar
Jamey
Icon for Helper I rankHelper I
5 years ago
Solved

How to SUM an AVERAGE Column

I have a table that can contain multiple entries with header information for the same Invoice - see example: Customer | Invoice No | Sales      | Production Order | Cost Qty XYZ Inc       12345601 ...
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    5 years ago

    Jamey 

    Sorry, I missed a context transition in my reply, try it like this.

    SUMX Average CALCULATE = SUMX ( VALUES ( 'Table'[INVOICE_ITEM] ), CALCULATE ( AVERAGE ( 'Table'[GROSS_SALES] ) ) )

    I believe that is the value you are looking for yes?

     

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
5 years ago

Hi, Jamey 

I am still quite not sure whether I understood your question correctly, but please check the below picture and the sample pbix file's link down below.

My previous measure (Sales Fix) did not work, however, Sales Fix V2 is working.... I think.. Please check.

 

 

Sales Fix V2 =
SUMX( VALUES('RawData'[INVOICE_ITEM]), [Sales Fix])
 
 
 

Hi, My name is Jihwan Kim.


If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.


Linkedin: https://www.linkedin.com/in/jihwankim1975/

 

Jamey's avatar
Jamey
Icon for Helper I rankHelper I
5 years ago

Thank you Jihwan Kim!

This solution works but because it's a two step solution by using another Measure, I Accepted the other solution - thanks again!