Suming rows (average)

[PBINewbie920]

Hi! 

My data looks something like this :

Folder No	Order #	Amount
300	10024	$500
300	10025	$500
300	10026	$500
301	10032	$20
301	10033	$20

When I make a table it ends up adding all the $500s for Folder 300 to make my total $1500. The total I want is actually $500 because order 10024+10025+10026 =500. 

For 301, the total i want is $20, but it adds both up to make it $40

I tried using distinct or average, it throws off the totals of the table and just averages EVERYTHING.

Any tips?

Thanks!

Anyway to add a new columns that will make my data look like this 

[AlexisOlson]

How about this?

SUMX (
    VALUES ( Table1[Folder No] ),
    CALCULATE ( MAX ( Table1[Amount] ) )
)

[smpa01 · Accepted solution]

@PBINewbie920  measure

Measure2 = 
SUMX (
    GROUPBY (
        _tbl1,
        _tbl1[Folder No],
        "sum", MAXX ( CURRENTGROUP (), _tbl1[Amount] )
    ),
    [sum]
)