Highest / Lowest discount value

[shayla]

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! 

[Anonymous]

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.

[ray_codex]

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.