Value based on threshold

Hi Anonymous ,

Do you have such a table?

"I want to build a measure, which based on the value from another measure compared to the range the key fallls into, returns the value from presented table."

But I don’t quite understand what you want to calculate, can you list the return value of the measure you want to calculate? In addition, you seem to mention another measure, can you give its formula?

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.