How to show the maximum value in the table?

[bourne2000]

Hi

I am having below data in my table

Name	Category	Supply	Value
A	AH	BG	200
A	SH	FJ	300
A	AJ	DK	1000
B	DH	SJ	5000
B	FKG	DK	20
B	SH	WL	12

I need to take out the maximum value from the above table and expecting below output

My expected output 

Name	Category	Supply	Value
A	AJ	DK	1000
B	DH	SJ	5000

Can anyone advise how to do this?

[ribisht17]

Thanks for marking the answer :), have a good day!

Regards,

Ritesh

[Ashish_Mathur]

Hi,

These measures work

Max value = MAX(Data[Value])

Category at maximum value = CALCULATE(MIN(Data[Category]),FILTER(VALUES(Data[Value]),Data[Value]=max(Data[Value])))

Supply at maximum value = CALCULATE(MIN(Data[Supply]),FILTER(VALUES(Data[Value]),Data[Value]=MAX(Data[Value])))

[ribisht17 · Accepted solution]

Hi,

Please use this DAX

Max Value = if(CALCULATE(MAX('Community Ques'[Value]),ALLEXCEPT('Community Ques','Community Ques'[Name]))=sum('Community Ques'[Value]),1,0)

Filter this DAX to 1

Thanks,

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !! PL 300 Certification Series