Forum Discussion
Max value with column condition
Hi there! Anyone help me? I need bring the max value with column condition, creating the column "MaiorAtraso"...The answer can be through measure or custom column. Thank you in advance! T...
Anonymous
As a calculated column you can use
Column = CALCULATE ( MAX ( Table1[AtrasoBoleto] ), ALLEXCEPT ( Table1, Table1[Recebimento] ) )
AlBNo problems ;)
From that column "MaiorAtraso" after i will create "ranges" to separate them straight on sctruture, for example:
Table that i have:
Recebimento | AtrasoBoleto |
| 44444 | 330 |
| 44444 | 360 |
| 44444 | 300 |
| 55555 | -100 |
| 55555 | -70 |
| 55555 | -10 |
| 55555 | 5 |
| 111111 | 145 |
| 111111 | 300 |
| 111111 | 400 |
What i need:
Recebimento | AtrasoBoleto | MaiorAtraso |
| 44444 | 330 | 360 |
| 44444 | 360 | 360 |
| 44444 | 300 | 360 |
| 55555 | -100 | 5 |
| 55555 | -70 | 5 |
| 55555 | -10 | 5 |
| 55555 | 5 | 5 |
| 111111 | 145 | 400 |
| 111111 | 300 | 400 |
| 111111 | 400 | 400 |
After this, i will create conditional column at structure to make others visualizations, not only at matrix:
Recebimento | AtrasoBoleto | MaiorAtraso | Range |
| 44444 | 330 | 360 | from 355 to 360 |
| 44444 | 360 | 360 | from 355 to 360 |
| 44444 | 300 | 360 | from 355 to 360 |
| 55555 | -100 | 5 | from 1 to 5 |
| 55555 | -70 | 5 | from 1 to 5 |
| 55555 | -10 | 5 | from 1 to 5 |
| 55555 | 5 | 5 | from 1 to 5 |
| 111111 | 145 | 400 | from 395 to 400 |
| 111111 | 300 | 400 | from 395 to 400 |
| 111111 | 400 | 400 | from 395 to 400 |
Anonymous
As a calculated column you can use
Column =
CALCULATE (
MAX ( Table1[AtrasoBoleto] ),
ALLEXCEPT ( Table1, Table1[Recebimento] )
)