How to Get Sum Discount based on MIN MAX from multiple condition

[Zarig]

Hi, Everyone 

I have struggle for some days. I want to compare may value that fullfil from min and max to get the discount. Here for discount table. 

For the next one, if the value fullfil 2 min and max so the discount will be sum. For example the value is 65 it will get 2 discounts (1+2) so the discount will be 3. 

Actually I want to use measure so I can use filter in my report. For now I still use this measure

measure = IF(Table1[measure1] > MIN(Table2[MIN]) && Table1[measure1] < MAX(Table2[MAX),SUMX(Table2,[Discount]), 0)

And the value that I want compare is in another table. 

Thanks

[v-jayw-msft]

Hi @Zarig ,

Have trouble to follow. Please share the expected result.

Best Regards,

Jay