Forum Discussion
Solved
max value
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 1...
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.
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
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.