Getting the Maximum per Group

[Anonymous]

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	Vendor 2	4
A	Question 2	Vendor 1	9
A	Question 2	Vendor 2	7
B	Question 1	Vendor 1	9
B	Question 1	Vendor 2	5
B	Question 2	Vendor 1	9
B	Question 2	Vendor 2	7

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

This is the expected output:

Contacts	Question	System	Response	Max	IsMax
A	Question 1	Vendor 1	8	8	1
A	Question 1	Vendor 2	4	8	0
A	Question 2	Vendor 1	9	9	1
A	Question 2	Vendor 2	7	9	0
B	Question 1	Vendor 1	9	9	1
B	Question 1	Vendor 2	5	9	0
B	Question 2	Vendor 1	9	9	1
B	Question 2	Vendor 2	7	9	0

[Zubair_Muhammad · Accepted solution]

@Anonymous 

Try

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

[Anonymous]

Thank you! This works!