Forum Discussion
Max value with column condition
Anonymous
As a calculated column you can use
Column = CALCULATE ( MAX ( Table1[AtrasoBoleto] ), ALLEXCEPT ( Table1, Table1[Recebimento] ) )
Hi Anonymous
Try this:
1. Place a matrix visual in your report with Plan1[Recebimento] in rows
2. Place this measure in values of the matrix:
MaxAtraso = MAX(Plan1[AtrasoBoleto])
Hello! AlB
thank you for the answer, but i can make the column in structure because after i will create conditional column from them, so only visualization at matrix dont atempt me =/
Anonymous
Sorry, I'm afraid I don't understand what you mean
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