Forum Discussion

CupidC's avatar
CupidC
Helper II
3 years ago
Solved

Show minimum value from the beginning

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:

 

Need Help

6 Replies

  • Ahmedx's avatar
    Ahmedx
    Super User
    3 years ago

    pls try this

     

     

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

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

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

     

     

    • CupidC's avatar
      CupidC
      Helper II
      3 years ago

      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!!!

       

       

       

  • Ahmedx's avatar
    Ahmedx
    Super User
    3 years ago

     

     

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

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

     

     

    • CupidC's avatar
      CupidC
      Helper II
      3 years ago

      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