topic Re: Highest / Lowest discount value in DAX Commands and Tips

Highest / Lowest discount value

shayla — Mon, 04 Dec 2023 15:48:31 GMT

Hi All,

Instead having the lowest discount in the whole column, I would like to have the lowest discount % in each year.

Then I could have

- highest discount % in 2021 = -59.2%

- highest discount % in 2022 = -66.2%

- highest discount % in 2021 = -61.5%

the formula works fine when I created a actual table, but doesn't work when I'm don't.

Could anybody help?

Thanks!

Re: Highest / Lowest discount value

ray_codex — Mon, 04 Dec 2023 22:15:00 GMT

Not sure what your source table looks like, but what I would do is compare the result the discount% column with the other customer ids max discount. So, in stead of just calculating the discount percentage, make it like this:
IF(<discount%calculation> = CALCULATE(MIN(<discount%calculation>), ALL('SGP Sales'[Customer ID])), <discount%calculation>, BLANK())
Then, if you have the customer id's as rows in a matrix and use a AVERAGEX to iterate your summarized table you will only find the non blanks, that are the actual minimum discount percentage.

Not 100% sure if this works right away, but I think this will give you what you want with some tweaking.

Re: Highest / Lowest discount value

Anonymous — Mon, 25 Dec 2023 01:41:35 GMT

Hi shayla ,

You can create a new table and measure , try to write the contents of the return to measure.Your new table may not be detected by the computer.

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.