topic Re: Need a help with avoiding repeating values in DAX-New user in DAX Commands and Tips

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

Anonymous — Thu, 30 Jul 2020 15:14:23 GMT

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

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

Anonymous — Thu, 30 Jul 2020 14:29:15 GMT

I need it in measure. Thanks!

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

Anonymous — Thu, 30 Jul 2020 15:14:35 GMT

Hi Anonymous ,

Not very clear.

What will be the expected output 18 and 15 ?

Regards,

Harsh Nathani

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

nandic — Thu, 30 Jul 2020 15:17:08 GMT

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])

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

Anonymous — Thu, 30 Jul 2020 15:17:16 GMT

"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.

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

Anonymous — Thu, 30 Jul 2020 15:17:45 GMT

I needed total of maximum values. Thanks!

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

Anonymous — Thu, 30 Jul 2020 15:19:46 GMT

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)

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

Anonymous — Thu, 30 Jul 2020 15:29:15 GMT

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