Forum Discussion
Max per category in a column
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 ...
for a calculated column:
NewCol = CALCULATE ( MAX ( Table1[Count rows] ), ALLEXCEPT ( Table1, Table1[Item ID] ) )
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
Community Champion
Community Championfor a calculated column:
NewCol = CALCULATE ( MAX ( Table1[Count rows] ), ALLEXCEPT ( Table1, Table1[Item ID] ) )
Many thanks!
Problem solved!