Forum Discussion

Fidzi8's avatar
Fidzi8
Helper V
5 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

6 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 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
      Helper V
      5 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
        Super User
        5 years ago

        Fidzi8 , formatted

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