Retrieve the value from a column based on the max of f grouping if other column

[m_anees]

I need to visulize a card with the max of the total profit for each project No,but I need to visulize the project number not the max profit vlaue itself 

this is a sample of the data 

ProjectNo	Category	Profit
1	Lic	1000
1	Dev	1000
2	Lic	2000
2	Lic	1000
2	Dev	1000

This how I want to display the card 

"The Max project Number profit is"

2

Appricaite your help

[AlB · Accepted solution]

Hi @m_anees 

Place this measure in a card visual

Measure =
VAR aux_ =
    TOPN ( 1, ALL ( Table1[ProjectNo] ), CALCULATE ( SUM ( Table[Profit] ) ) )
RETURN
    "The Max project Number profit is " & MAXX ( aux_, [ProjectNo] )

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[m_anees]

Thank you so much 

[amitchandak]

@m_anees , Try a measure like

measure = "The Max project Number profit is" & CALCULATE(Max(Table[Project]),TOPN(1,all(Table[ProjectNo]),calculate(Sum(Table[Profit])),DESC),VALUES(ProjectNo[ProjectNo]))

TOPN should help : https://www.youtube.com/watch?v=QIVEFp-QiOk

[m_anees]

Thank you so much it's working