Rank with Most From One and Least From Another

[PPalkowski]

I am trying to get a way to rank for the most Reports with the Least Missing Data Here is my table

Name	Reports	Missing Data	RankMostReports	RankLeastMissing
Bruce Wayne	111	1	1	2
Clark Kent	69	0	3	1
James Gordon	89	25	2	5
Wally West	38	0	5	1
Hal Jordan	62	5	4	3

So, I want my visual to show only Clark Kent , what would be the DAX for that measure?

[Anonymous]

This measure returns 1 if the rows should be visible and 0 if not.

[Should Show] =
var __onlyOneNameVisible = HASONEVALUE( T[Name] )
var __isNameColumnSelected = ISFILTERED( T[Name] )
var __shouldCalc =
	__onlyOneNameVisible
	&& __isNameColumnSelected
var __allVisibleNames = ALLSELECTED( T[Name] )
var __currentName = VALUES( T[Name] )
var __nameWithTheProperty =
	topn(1,
		filter(
			__allNames,
			[RankLeastMissing] = 1
		),
		[Reports],
		desc
	)
RETURN
	if( __sohuldCalc,
		1 * ( __nameWithTheProperty = __currentName )
	)

Best

D

[Greg_Deckler]

Perhaps:

Measure =
  VAR __Most = MAXX(ALL('Table'),[RankMostReports])
  VAR __Least = MINX(ALL('Table'),[RankLeastMissing])
RETURN
  IF(__Most = MAX([RankMostReports]) && __Least = MAX([RankLeastMissing),1,0)

[PPalkowski]

This is the error I get

The MAX function only accepts a column reference as the argument number 1.