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.
thank you for the support