Value based on threshold

[macinr]

Hi,

I make heavy use of dynamic parameters. 

They allow to select a value and recalculate the results  in real time. That helps a lot.

However I reached a problem which I am not sure how to solve:

I have a list of key values:

10 - 1000

20 - 2000

50 - 3000

100 - 4000

150 - 5000

Where the key is actually a range. The table reads:

From 0 to 10 value is 1000

From 10+ to 20 value is 2000

Etc

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.

What is the best approach for solving such a problem?

[v-lionel-msft]

Hi @macinr ,

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.

[macinr · Accepted solution]

This is exactly what I needed 🙂

https://community.powerbi.com/t5/Quick-Measures-Gallery/LOOKUPVALUE-Range/td-p/974201