Find a number in a table when it is greater than or equal to the value of a measure

[Syndicate_Admin]

Hello good, I was wondering if there is a way to find the first value in a table that is greater than or equal to the value of a measure, attached brief example:

I have the "Excess Savings" column that contains integers and decimals:

I want to make a measurement that is able to search within that list for the first number that is equal to or greater than the following calculated measure:

My idea had been something like that but it didn't really work:

In addition, it must respond to the filters that are applied to it when necessary. I put a screenshot for greater exemplification:

1.- I currently have 2 simple segmenters that define the value of the other measures within the red square plus.

2.- In addition, I have to third segmenter which I want to remove (by filtering by the value 108 I get the score that makes the measures highlighted by the black arrow are the same.

3.- The measure highlighted in yellow is the one I mentioned as "Cut-Total" which is the one I want to look for within the values of the table I attached.

4.- Finally I would like to reach the value I need to reach the desired score (in that case 108) without having to filter by that value and go proving what number serves me, that is, that it is calculated automatically.

I will give one last example:

When the Cut-Total measure is = 55.5 (for example)

I want the desired measure to create to bring me the value 56 of the following table, since it is the first value that equals or exceeds it:

I remain attentive and thank you very much.

[amitchandak · Accepted solution]

@Syndicate_Admin , use filter then that clause should work

example

calculate([meausre], filter(Table, [Measure1] >= [measure2]))

[Syndicate_Admin]

Worked! Thank you very much!