topic Re: Minx in DAX Commands and Tips

Minx

Talal141218 — Wed, 24 Aug 2022 08:44:22 GMT

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 — Wed, 24 Aug 2022 08:55:56 GMT

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 — Wed, 24 Aug 2022 09:09:58 GMT

Thank's alot

Talal141218 — Wed, 24 Aug 2022 10:34:37 GMT

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

what should i do ?

Jihwan_Kim — Wed, 24 Aug 2022 10:58:31 GMT

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 — Wed, 24 Aug 2022 12:21:47 GMT

thanks for your effort, but unforetunately did not work .

Jihwan_Kim — Wed, 24 Aug 2022 12:29:30 GMT

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 — Wed, 24 Aug 2022 14:54:14 GMT

thank's i found a solution