cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
ogureisuo Regular Visitor
Regular Visitor

Getting the Maximum per Group

Can anyone help me? I got stuck by getting the highest number per group.

 

Here is my sample table:

 

ContactsQuestionSystemResponse
AQuestion 1Vendor 18
AQuestion 1Vendor 24
AQuestion 2Vendor 19
AQuestion 2Vendor 27
BQuestion 1Vendor 19
BQuestion 1Vendor 25
BQuestion 2Vendor 19
BQuestion 2Vendor 27

 

I need to get the max/biggest number per Contacts and Question.

This is the expected output:

 

ContactsQuestionSystemResponseMaxIsMax
AQuestion 1Vendor 1881
AQuestion 1Vendor 2480
AQuestion 2Vendor 1991
AQuestion 2Vendor 2790
BQuestion 1Vendor 1991
BQuestion 1Vendor 2590
BQuestion 2Vendor 1991
BQuestion 2Vendor 2790
1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Getting the Maximum per Group

@ogureisuo 

 

Try

 

 

Max=
CALCULATE (
    MAX ( Table1[Response] ),
    ALLEXCEPT ( Table1, Table1[Contacts], Table1[Question] )
)
2 REPLIES 2
Super User
Super User

Re: Getting the Maximum per Group

@ogureisuo 

 

Try

 

 

Max=
CALCULATE (
    MAX ( Table1[Response] ),
    ALLEXCEPT ( Table1, Table1[Contacts], Table1[Question] )
)
ogureisuo Regular Visitor
Regular Visitor

Re: Getting the Maximum per Group

Thank you! This works!