Forum Discussion

Fidzi8's avatar
Fidzi8
Icon for Helper V rankHelper V
6 years ago

MIN Value

Hi, I  need min value 115.   When I filter month June, I see min value 121 - besause Haulier had this month 121.  I need always the same min value of LOG_CODE.   Thank you  Ondřej
Need Help
Tips and Tricks
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Fidzi8 , you need [CostP] the Min or You can use a formula in place of that

 

Without considering filter

minx(filter(all(Table),Table[log_code] ="T00265401970"), [CostP])
calculate([CostP], filter(all(Table),Table[log_code] ="T00265401970"))

 

filter are considered

minx(filter(allselected(Table),Table[log_code] ="T00265401970"), [CostP])
calculate([CostP], filter(allselected(Table),Table[log_code] ="T00265401970"))

  • Fidzi8's avatar
    Fidzi8
    Icon for Helper V rankHelper V
    6 years ago

    amitchandak, 
    I couldn´t use second part your formula 😕

     

    I adjusted your formula but does not work 😕

    Thank you
    Ondřej

    • amitchandak's avatar
      amitchandak
      Icon for Super User rankSuper User
      6 years ago

      Fidzi8 , formatted

       minx( filter(all(Table)
                             ,Table[log_code] ="T00265401970"
                             )
             , [CostP])

      • Fidzi8's avatar
        Fidzi8
        Icon for Helper V rankHelper V
        6 years ago

        amitchandak ,
        I can´t use "T00265401970" because I have a lot of unique codes

        I don´t know how use all DATE in this formula

        Thank you
        Ondřej