Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
64 |