Need a help with avoiding repeating values in DAX-New user

[Anonymous]

Hello, I am a new user of PowerBi. I  need a sum of Maximum bid values of an Item.  Please suggest how should I do it. Thanks!

Itemid	Bid($)	BidderID
A	10	1
A	12	2
A	14	3
A	16	4
A	18	5
B	10	3
B	15	5
B	15	4
B	15	8

[Anonymous]

[Sum Of Max] =
SUMX(
    VALUES( T[ItemID] ),
    CALCULATE( MAX( T[Bid] ) )
)

[Anonymous]

I need it in measure. Thanks!

[Anonymous]

"I need a sum of Maximum bid values of an Item."

An item can have just one maximum bid by definition, so there's nothing to sum.

[nandic · Accepted solution]

@Anonymous ,

Here is the formula:

Sum max values =

var MaxPerItem =
ADDCOLUMNS(

     SUMMARIZE('Table','Table'[Itemid ]),

     "Max Value",

     CALCULATE(MAX('Table'[Bid($)])

)

)

RETURN

SUMX(MaxPerItem,[Max Value])

[harshnathani]

Hi @Anonymous ,

Not very clear.

What will be the expected output 18 and 15 ?

Regards,

Harsh Nathani

[Anonymous]

I  needed total of maximum values. Thanks!

[harshnathani]

Hi @Anonymous ,

Solution provided above.

But sharing since I worked on it too

Sum of Max Bids = 
var Maxvalue =
     SUMMARIZE('Table','Table'[Itemid ],
     "Max Value",
     CALCULATE(MAX('Table'[Bid($)])
)
)
RETURN
SUMX(MaxValue,[Max Value])

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)