Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Value based on threshold

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?

Need Help
Show and Tell

2 Replies

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    6 years ago

    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.