Create a measure that shows the name of the minimum value of a related column

[PwrBI01]

Hi guys,

I have the following table:

I want to create a measure that shows the name of the person that has the minimum ID, how can I do it?

Thanks in advance.

[Fowmy]

@PwrBI01 

Try this measure:

Name_m =TOPN(1,VALUES(Table[Name]),CALCULATE(MAX(Table[ID])),ASC)

[PwrBI01]

Hi @Fowmy, thank you for your answer,

If I use the measure you sent me I get Blank as a result, but if I change it into the opposite:

Name_m =TOPN(1,VALUES(Table[Name]),CALCULATE(MAX(Table[ID])),DESC)

I get the result Ricardo, do you know where can be the problem?

Regards.

[Fowmy · Accepted solution]

@PwrBI01 

It works for me. check your dataset if you have a blank in the Name column. 

Try this modified version

TOPN(1,FILTER(VALUES('Table'[Name]),'Table'[Name]<>BLANK()),CALCULATE(MAX('Table'[ID])),ASC)

[PwrBI01]

@Fowmy I checked the database and I didn't see any blank data. Anyway this modified version worked fine. 

Thank you.