calculating the Sum of the highest values for each “ID”

[Mohammadshareef]

Regards,

I need your support on the following matter:

I have a table of clients’ names after adding Queries Edits.

 Tools used: Slicer for Receive Date & #Round columns.

I need support in calculating the Sum of the highest values in “Quantity Column” for each “ID”

Example (Before Filter):

The highest value in “Quantity” for “ID: 1” is “ 7 ”

The highest value in “Quantity” for “ID:2” is “ 9 ”

The highest value in “Quantity” for “ID:3” is “ 4 ”

The highest value in “Quantity” for “ID:4” is “ 4 ”

The result I want to have is ( 7 + 9 + 4 + 4 = 24 ).

Example (With Filter): Using Filter for “Receive Date” for “1/1/2016, 2/1/2016”

The highest value in “Quantity” for “ID: 1” is “ 5”

The highest value in “Quantity” for “ID:2” is “ 8”

The highest value in “Quantity” for “ID:3” is “ 4 ”

The result I want to have is ( 5 + 8 + 4 = 17 ).

Thank you for your support.

[BhaveshPatel · Accepted solution]

Hi Mohammed

Try this measure,

SumOfMaxes:=SUMX(
VALUES(Table1[ID])
,CALCULATE( MAX(Table1[Quantity]) )
)

and 

SumOfMaxesfor2:=SUMX(
VALUES(Table1[Receive Date])
,CALCULATE( MAX(Table1[Quantity]) )
)

Hope this would solve your problem.

[Mohammadshareef]

Many thankssssssssssss