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

Zarig — Wed, 02 Nov 2022 04:27:28 GMT

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

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

Anonymous — Thu, 03 Nov 2022 09:11:15 GMT

Hi Zarig ,

Have trouble to follow. Please share the expected result.

Best Regards,

Jay

topic How to Get Sum Discount based on MIN MAX from multiple condition in DAX Commands and Tips

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

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