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:]
)
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 . 

    • Jihwan_Kim's avatar
      Jihwan_Kim
      Icon for Super User rankSuper User
      4 years ago

      Hi,

      Please share your sample pbix file's link here, and then I can try to look into it to come up with a more accurate solution.

      Thanks.

      • Talal141218's avatar
        Talal141218
        Icon for Helper III rankHelper III
        4 years ago

        thank's i found a solution