Max per category in a column

[Anonymous]

Hi Community,

i'm struggling with a seemingly simple problem :).

I have a column with Items (Item ID), multiple item ID's possible. Next to that a calculated column with count rows:

Item ID   Count rows

H32WB    3

H32WB    5

A78VB     27

A78VB    36

I would like to create a new calculated column which displays the highest value from count row. But the highest per Item ID. So for example the highest for Item H32WB would be 5, for A78VB 36 and so on. Many thanks for your help :).

[AlB]

Hi @Anonymous 

1. Place ItemID in the rows of a table visual

2. Create a simple measure and place it in the visual

Measure = MAX(Table1[Count rows])

Please mark the question solved when we get to the solution and consider kudoing if posts are helpful.

Cheers  

[Anonymous]

Hi,

many thanks for the reply. But that will not give me the max per category, just the max for the column.

Further I need a solution within a calculated column not measure :).

If my question was not clear.

In column Item ID's are double Item ID's, count row indicates the counted rows (lines). I need the max counted row per Item ID. So if there are for example 2 item IDs with ID ABCD123, one with value 4 and one with value 5 -> I need to see the max value in this case 5.

[AlB · Accepted solution]

for a calculated column:

NewCol =
CALCULATE ( MAX ( Table1[Count rows] ), ALLEXCEPT ( Table1, Table1[Item ID] ) )

[Anonymous]

Many thanks!

Problem solved!