Filing a column with the min value of another column

[r_ramillien]

Hello all,

I stuck on a problem which seems very basic.

I would like to create a column or measure which contains the minimum value of all rows of another column.

I want to it to be sensitive to filters, that's why I can't use power query.

To make an example, I have a table like this.

key | value

0    | 10

0    | 20

0    | 30

1    | 5

Supposing I have a filter on key 0, I would have someting like this:

key | value | min

0    | 10      | 10

0    | 20      | 10

0    | 30      | 10

This is not my "real" use case. But I need this step to implement it.

I tried a lot of solutions based on min, mina, minx, etc. Using columns or measures, but nothing seems to work. In most cases, the min value is equal to the value of the same row. So, how can I do to fill all the rows with the min value found in filtered rows ?

I think I approches a solution with this kind of formula:

CALCULATE(MIN('Test'[value]), ALLEXCEPT('Test', 'Test'[key], 'Test'[another column]))

But if I remove the "allexcept", this do not works anymore. I would not add all my segments in the allexcept. I would like CALCULATE to use the segments on the page.

Best regards,

[mahoneypat · Accepted solution]

To have it respond to slicers, it needs to be a measure.  Please try this one.

MinThisKey = CALCULATE(MIN(test[value]), ALL(test[Value]))

Pat

[r_ramillien]

Hello,

Thank you, it works great !

When I read the documentation for "ALL", I understand that it resets all filters. So I thought the result for all rows would have been "5" instead of 10. I'm not sure to understand how it works then, but it works. Thank you !

[CNENFRNL]

Resort to Calculated Column since it's only an intermediate step.

[r_ramillien]

Hello,

Thank you for your help, I see that it works for you. But the same code do not works for me !?

It says "EARLIER/EARLIEST make a reference to a previous row context which do no exists."

Any idea please ?