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

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