Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
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
@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)
ihave done this but it doesnt work can you correct it for me ?
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.
User | Count |
---|---|
98 | |
91 | |
84 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |