Solved: MIN VALUE WHEN NA VALUE EXCLUDE

PriscaSalve · ‎08-16-2023

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

Anonymous · ‎08-22-2023

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.

View solution in original post

Anonymous · ‎08-22-2023

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 · ‎08-16-2023

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!