Max value with column condition

[Anonymous]

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!

Table name: Plan1

Structure:

Recebimento	AtrasoBoleto
44444	330
44444	360
44444	300
55555	-100
55555	-70
55555	-10
55555	5
111111	145
111111	300
111111	400

How i expected:

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

[AlB]

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])

[Anonymous]

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 =/

[AlB]

@Anonymous

Sorry, I'm afraid I don't understand what you mean

[Anonymous]

@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

[Zubair_Muhammad · Accepted solution]

@Anonymous

As a calculated column you can use

Column =
CALCULATE (
    MAX ( Table1[AtrasoBoleto] ),
    ALLEXCEPT ( Table1, Table1[Recebimento] )
)

[Anonymous]

@Zubair_Muhammad

Thank you so much! Im looking the answer fo a long time :D:D:D !!

Best regards,