Minx

[Talal141218]

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 · Accepted solution]

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]

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

what should i do ? 

[Jihwan_Kim]

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]

thanks for your effort, but unforetunately did not work . 

[Jihwan_Kim]

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]

thank's i found a solution 

[Talal141218]

Thank's alot