Only count/sum Quantity of last log date

[rpinxt]

So I have this table output:

So I have a delivery with multiple materials.

But some of these materials (see for example the yellow) have 2 log dates.

The correct Quantity for  this material would be 2 and not 4 (when I would take out the date)

Made QCorr like :

QCorr = CALCULATE([Quantity],Test[LogDate] = Test[MaxLog])

Actually expected this would work. No clue why it still shows 2 where logdate is 18 and maxlog is 19.

But this is not doing what I want.

In the end I want to take the dates out and that material should show 2.

Because the total should be 102 not 122.

122 is because all of the doubles in this delivery.

How can I make it 

[rpinxt]

@mlsx4 
unfortunately not:

ps: maxlog is a calculated column

[mlsx4]

Hi @rpinxt 

I have created an auxiliary sum to get the maximum value in case of several rows:

sumSc = CALCULATE(MAX('Table'[Quantity]), FILTER(ALLEXCEPT('Table','Table'[Material]), 'Table'[LogDate]=MAX('Table'[LogDate])))

 And now, in QCorr:

QCorr = SUMX(VALUES('Table'[Material]),IF(DISTINCTCOUNT('Table'[Material])>1,[sumSc],SUM('Table'[Quantity])))

You don't need any "MaxLog" column

[rpinxt]

Thanks @mlsx4 but look on the second row....it says 4 and should be 2.

Yes your total of 102 is correct but if you sum all the line separate you will again get 122.

[mlsx4 · Accepted solution]

Opsss... I copied badly the measure:

QCorr = SUMX(VALUES('Table'[Material]),[sumSc])

[rpinxt]

Yes thanks @mlsx4 this seems to work.
But you need to remove the date colunns.

This is part of a bigger thing.

I have more countries, deliveries and months etc.

I should all go into a stacked column chart.

With periods on the x-axis where I link a date field (maxlog) to a date table (auto).

Wondering if it will give the correct output.

But will test. Thanks for this!

[mlsx4]

I think you shouldn't include those columns in the table or they will be added to the sum. If you just leave delivery, material and qcorr, it should work.