Forum Discussion

Talal141218's avatar
Talal141218
Icon for Helper III rankHelper 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:]
)
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper 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
    Icon for Helper III rankHelper III
    4 years ago

    Thank's alot

  • Talal141218's avatar
    Talal141218
    Icon for Helper III rankHelper 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
      Icon for Super User rankSuper 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:]
)
      • Talal141218's avatar
        Talal141218
        Icon for Helper III rankHelper III
        4 years ago

        thanks for your effort, but unforetunately did not work .