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

v-danhe-msft's avatar
v-danhe-msft
Microsoft Employee
7 years ago

Hi Anonymous,

Based on my test, you could refer to below steps:

Sample data:

Create below measure:

Measure = CALCULATE(SUM(Table1[Total Sales]),FILTER(ALL('Table1'),'Table1'[Order Number]=MAX('Table1'[Order Number])))

Result:

You could also download the pbix file to have a view.

 

Regards,

Daniel He

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Daniel,

 

I used your formula but PBI is giving me an error stating there are too few arguments for the FILTER function and it requires a minimum of 2?

 

Remembering that I need this to be a New Column and not a Measure, would that make a difference with the formula required?

 

Sorry, still very new to DAX and trying to get my head around it all.

 

Thanks,

Paul

  • v-danhe-msft's avatar
    v-danhe-msft
    Microsoft Employee
    7 years ago

    Hi Anonymous,

    Could you please offer me a sample file and post your desired result if possible? So I could test for your desied result.

     

    Regards,

    Daniel He