I need to get the cheapest value per group

[victormarconis]

Hello, I need to get the cheapest value per group, but I can't in any way, I've already researched and it never works for me.

Minimum = CALCULATE(MIN(UltimasEntradas[UltimoValor]),ALLEXCEPT('apresentaçao', 'apresentaçao'[apresentacao]))

I would like the "Minimum" column to contain the minimum value per group, which in this case would be "4.99". I need this value in all lines, because later I will have to do another calculation to see the difference between the minimum and the "last value"

[Martin_D · Accepted solution]

Did you already try:

Minimum = CALCULATE(MIN(UltimasEntradas[UltimoValor]),ALLSELECTED())

[Martin_D]

You are right, the on screen order ofthe posts is a bit confusing sometimes, but the message numbers are clear 😉

[Martin_D · Accepted solution]

Did you already try:

Minimum = CALCULATE(MIN(UltimasEntradas[UltimoValor]),ALLSELECTED())

[victormarconis · Accepted solution]

I got it this way below, you opened my mind, thank you very much.

MinimumGroup = CALCULATE( MIN(UltimasEntradas[UltimoValor]), ALLEXCEPT(UltimasEntradas, 'apresentaçao'[apresentacao])

[victormarconis]

It even works on a separate Card, then I apply the filter and it works, but I wanted this column to appear in my visual table, and by group, not in general as in this case. Can you help me, thank you very much.

[Martin_D]

Would you mind posting a screenshot of the whole report page, where you currently are, and what should behave differently?

[victormarconis]

It's already been solved, look at the other answer, thanks