Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Getting the Maximum per Group

Can anyone help me? I got stuck by getting the highest number per group.   Here is my sample table:   Contacts Question System Response A Question 1 Vendor 1 8 A Question 1 Vendo...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    Anonymous 

     

    Try

     

     

    Max=
CALCULATE (
    MAX ( Table1[Response] ),
    ALLEXCEPT ( Table1, Table1[Contacts], Table1[Question] )
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
7 years ago

Anonymous 

 

Try

 

 

Max=
CALCULATE (
    MAX ( Table1[Response] ),
    ALLEXCEPT ( Table1, Table1[Contacts], Table1[Question] )
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thank you! This works!