Forum Discussion
Solved
Filter by column "Unit" to get filter "Highest " value
| UNIT | VALUE | |
| A | 0 | |
| A | 1 | |
| A | 2 | |
| B | 0 | |
| B | 1 | |
| B | 2 | |
| C | 0 | |
| C | 1 | |
| C | 2 | |
| C | 3 | |
| D | 0 | |
| D | 1 | |
| D | 2 | |
| D | 3 | |
| D | 4 | |
| D | 5 | |
| D | 6 |
| Expected reults: | |
| A | 2 |
| B | 2 |
| C | 3 |
| D | 6 |
Max Value = MAX(Table[Value])
| UNIT | VALUE | |
| A | 0 | |
| A | 1 | |
| A | 2 | |
| B | 0 | |
| B | 1 | |
| B | 2 | |
| C | 0 | |
| C | 1 | |
| C | 2 | |
| C | 3 | |
| D | 0 | |
| D | 1 | |
| D | 2 | |
| D | 3 | |
| D | 4 | |
| D | 5 | |
| D | 6 |
| Expected reults: | |
| A | 2 |
| B | 2 |
| C | 3 |
| D | 6 |
Max Value = MAX(Table[Value])
