Forum Discussion

160475's avatar
160475
Helper I
3 years ago
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...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    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.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

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's avatar
    160475
    Helper I
    3 years ago

    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's avatar
      Greg_Deckler
      Community Champion
      3 years ago

      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.