Lookup a value and assign a calculation in a measure

[salonikhedkar_1]

Hi

I am looking for a help with a measure such that I want to lookup a value from a list of values and assign a simple calculation.

For example,

if category = apple then (TotalAmount - 600)/600

else if category = pear then (TotalAmount - 1000)/ 1000

and so on.

i am unable to achieve this on a Measure and your help will be appreciated. 

[AllisonKennedy · Accepted solution]

This looks like a SWITCH function, but can you please provide sample data tables of raw input data and then desired output. You can use the SELECTEDVALUE(Table[Category]) to grab the category value;
SWITCH(SELECTEDVALUE(Table[Category])
, "Apple", DIVIDE( [Total Amount] - 600, 600)
, "Pear" , DIVIDE ( [Total Amount] - 1000, 1000)
)

[salonikhedkar_1]

Allison,

Thank you so much ! Its the perfect solution.

[AllisonKennedy]

Glad it worked! 🙂 You are very welcome.