topic MIN VALUE WHEN NA VALUE EXCLUDE in DAX Commands and Tips

MIN VALUE WHEN NA VALUE EXCLUDE

PriscaSalve — Wed, 16 Aug 2023 17:29:06 GMT

I WANT TO GET MIN SCORE AS 5 BUT ITS SHOWING AS 10 COULD SOMEONE HELP IN DAX

Re: MIN VALUE WHEN NA VALUE EXCLUDE

AnthonyGenovese — Wed, 16 Aug 2023 21:23:48 GMT

Your data type is character, not a number. 10 is less than 5. Create a new column in Power Query that only has numeric values and cast that data type correctly, or remove non-numeric values in the source.

If this post was helpful, please kudos or accept the answer as a solution.
~ Anthony Genovese
Need more PBI help? PM me for affordable, dedicated training or consultant recomendations!

Re: MIN VALUE WHEN NA VALUE EXCLUDE

Anonymous — Tue, 22 Aug 2023 07:32:30 GMT

Hi PriscaSalve ,

Please try to create a measure with below dax formula:

Measure = VAR tmp = FILTER ( ALL ( 'Table' ), NOT ( ISERROR ( INT ( [score] ) ) ) ) RETURN MINX ( tmp, INT ( [score] ) )

Please refer the attached .pbix file.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.