Forum Discussion

Talal141218's avatar
Talal141218
Helper III
4 years ago
Solved

Minx

Hi there, 

 

i am neu with Power BI and i want to apply Minx to find the minimum value for net sales except(0 or blank). 

anyone can help me in this? 

thanks in advance. 

  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    Hi,

    I am not sure how your dataset looks like, but please check the attached file.

    I hope the below attached file can provide some ideas on how to create a solution for your dataset.

     

    Min sales measure: =
MINX (
    FILTER ( Sales, Sales[Sales] <> 0 && Sales[Sales] <> BLANK () ),
    [Sales total measure:]
)

7 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    4 years ago

    Hi,

    I am not sure how your dataset looks like, but please check the attached file.

    I hope the below attached file can provide some ideas on how to create a solution for your dataset.

     

    Min sales measure: =
MINX (
    FILTER ( Sales, Sales[Sales] <> 0 && Sales[Sales] <> BLANK () ),
    [Sales total measure:]
)
    • Talal141218's avatar
      Talal141218
      Helper III
      4 years ago

       

      sorry sir just one question. If i want add minus values to the filter. values >0 

      what should i do ? 

       

      • Jihwan_Kim's avatar
        Jihwan_Kim
        Super User
        4 years ago

        Hi,

        Thank you for your feedback, and please try something like below.

         

        Min sales measure: =
MINX (
    FILTER ( Sales, Sales[Sales] > 0 && Sales[Sales] <> BLANK () ),
    [Sales total measure:]
)