Choose the bigger value if more than one are in data when doing summarize()

[Rudd_ThreeTrees]

Hello everyone

Following problem:

table with Orders:

Material	Quantity	Unit	BaseUnits
1	10	OP	100
1	15	OP	300
2	1	OP	10

Out of this table i want to create a calculated table with the the Material-ID and the meaning of the Unit for example:

Material	Meaning OP
1	HERE IS THE PROBLEM
2	10

So as you can see the data for material 1 is not correct or did change over the time i have the data... The OP can mean 10 or 20.
So if this occurs, i want to choose allways the biggest value.

The lookup table is calculate with the summarize() function.

Thanks you very much for every hint or help.

Cheers

[Ahmedx · Accepted solution]

pls try this

Table 2 = ADDCOLUMNS(SUMMARIZE('Table','Table'[Material]),"Meaning OP",CALCULATE(MAX('Table'[BaseUnits])))