max value

[160475]

dears,

good day!! 

the table below has the same number in rows, how to show only the max value ? note that i'm just filtring on one number as i have many numbers in the table 

which is branch 141 and cteller tnx 4 

[160475]

thank you for the support 

[Greg_Deckler]

@160475 Maybe try a Complex Selector:

Selector =
  VAR __Number = MAX('Table'[Number])
  VAR __MaxBranch = MAXX(FILTER(ALL('Table'),[Number] = __Number),[Branch])
  VAR __Branch = MAX('Table'[Branch])
RETURN
  IF(__MaxBranch = __Branch,1,0)

[160475]

ihave done this but it doesnt work can you correct it for me ? 

Selector =

VAR FinalCIF = MAX('Transactions[FinalCIF])

VAR Max Branch = MAXX(FILTER(ALL('transactions'),[FinalCIF] = FinalCIF),[Branch])

VAR Branch = MAX('transactions'[Branch])

RETURN

IF(MaxBranch =Branch,1,0) 

thank you

[Greg_Deckler · Accepted solution]

@160475 

Selector = 
VAR FinalCIF = MAX('Transactions'[FinalCIF])
VAR MaxBranch = MAXX(FILTER(ALL('transactions'),[FinalCIF] = FinalCIF),[Branch])
VAR Branch = MAX('transactions'[Branch])
RETURN
IF(MaxBranch =Branch,1,0)

The 2 issues were, you need single quotes around your table names ( you were missing a closing single quote in your FinalCIF VAR line. Also, variables (VAR) names cannot have spaces in them.