Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Syndicate_Admin
Administrator
Administrator

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

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:

CPBI_J_0-1644425195074.png

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.

1 ACCEPTED SOLUTION

Hi @Syndicate_Admin ,

 

Please try the following measure:

 

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

vkkfmsft_0-1644816666628.png

 

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.

 

View solution in original post

3 REPLIES 3
parry2k
Super User
Super User

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



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

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

CPBI_J_0-1644439140207.png

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

In addition, I have the following measure:

CPBI_J_1-1644439311595.png

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

CPBI_J_2-1644439339569.pngCPBI_J_3-1644439348999.png

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.

Hi @Syndicate_Admin ,

 

Please try the following measure:

 

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

vkkfmsft_0-1644816666628.png

 

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.

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.