Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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 ...
Need Help
  • AlB's avatar
    AlB
    7 years ago

    for a calculated column:

    NewCol =
CALCULATE ( MAX ( Table1[Count rows] ), ALLEXCEPT ( Table1, Table1[Item ID] ) )
AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
7 years ago

for a calculated column:

NewCol =
CALCULATE ( MAX ( Table1[Count rows] ), ALLEXCEPT ( Table1, Table1[Item ID] ) )
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Many thanks!

Problem solved!