Show minimum value from the beginning

[CupidC]

Hi 

I have a simple measure aimed at displaying the minimum value consistently, and I wrote the measure below, i am not sure why it doesn't work. please help 😞

Min Value =

CALCULATE([Total],FILTER(all('Table'),'Table'[Sort]=min('Table'[Sort])))

Result that i am getting(wrong)

 The result that i would like to be:

[CupidC]

Hi Ahmedx, thanks a lot!! it works perfectly!

[Ahmedx]

M1 = MINX(ALLSELECTE('Table'),[Total])
--------or -------

Measure = CALCULATE(MIN('Table'[ Total]),ALLSELECTE())

[CupidC]

Hello Ahmedx,

Thank you once again for your help! The solution works perfectly.

I was curious if there are other ways to achieve the same result without using "Allselected". I came across a few articles online that suggested "Allselected" can be complex and may not always produce accurate results, so it's best to avoid it if possible.

Are there any alternative methods you would recommend?

Thanks

[Ahmedx · Accepted solution]

it is possible, but for this you need to create a dimension table, see file

https://1drv.ms/u/s!AiUZ0Ws7G26Rh2X45QCNGe1N2rDy?e=1dXrAg

[Ahmedx]

pls try this

M1 = MINX(all('Table'),[Total])

--------or -------

Measure = CALCULATE(MIN('Table'[ Total]),REMOVEFILTERS())

[CupidC]

Hello Ahmedx,

Thank you so much for your help! It worked perfectly.

I was wondering if you could show me how to make it work with a slicer as well?

For instance, if the slicer starts from 2, I would like the minimum value to be 200.

If it starts from 3, the minimum value should start from 300 and so on.

thank you!!!