Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Sum column values by same row value

Hi there,   I have a table which reflects my itemised sales data and includes the following:   Order Number Item Code Item Description Qty Total Sale The same order number can be present o...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Daniel,

     

    I found the error I made, there was a single ")" I missed in the formlua which was difficult to spot...

     

    However, I found that the correct formula was in fact to use EARLIER and not MAX.

     

    Thanks,

    Paul

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Daniel,

 

I found the error I made, there was a single ")" I missed in the formlua which was difficult to spot...

 

However, I found that the correct formula was in fact to use EARLIER and not MAX.

 

Thanks,

Paul

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Now I have a different issue but related to the same source formula.

 

Now that I have the correct sum of the line items per PO, I need to get an average of those totals. When I place the field in a Card and specify for it to be presented as an average, it gives me an incorrect answer. When I export the table with PO numbers and totals for those POs I get the correct average which is lower than the Card.

 

Now if I create the below Measure the average is calculated correctly. Why?

 

Average PO Spend = AVERAGEX(SUMMARIZE(Table, Table[PO], "to Average", [Spend Measure]), [Spend Measure])

 

Spend Measure = CALCULATE([Total Spend], FILTER(Table, Table[PO]))