MIN VALUE WHEN NA VALUE EXCLUDE

[PriscaSalve]

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

[Anonymous · Accepted solution]

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.

[AnthonyGenovese]

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!