Find value in a table that is greater than or equal to the value of a measure

[Syndicate_Admin]

Hello good, I am new to pbi and I was wondering if there is to find a value in a table that is greater than or equal to the value of a measure (that is, find the first number that is greater than or equal to a measure already created), 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 another measure that is already created.

I remain attentive and thank you very much.

[parry2k]

@Syndicate_Admin what do you mean by measure already created? Can you provide more context/details?

[Syndicate_Admin]

Yes of course, as I said I have the following table:

Where the "UF" column is only positive integers, and the "Excess Savings" column are integer positive numbers.

In addition, I have the following measure:

Which is the sum of other measures that are also sums:

I want to find the value in the "UF" column when the number in the "Excess savings" column is the first to be equal to or greater than the "Cut-Total" measure.

So for example, when the measure "Cut-Total" of as value 55.5 I want the desired measure to bring me the value UF 15.

I hope I have made myself understood. Thank you very much from now.

[v-kkf-msft · Accepted solution]

Hi @Syndicate_Admin ,

Please try the following measure:

_UF = 
MINX (
    FILTER (
        'Table',
        'Table'[Excess Savings] >= CALCULATE ( [Measure], ALL ( 'Table' ) )
    ),
    'Table'[UF]
)

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.