remove the values which start with 0. or -0.

[mypowerbi1]

Hi,

One of the measure gives output in the range of -800000 to +900000 range. 

I need to remove all those values from a measure's output which start eaither -0. or 0.

please suggest how to remove them.

Thanks

[devesh_gupta]

@mypowerbi1 Try to use the following dax if it works for you:

= CALCULATE (
    <measure>,
    FILTER (
        ALL ( <table> ),
        LEFT ( <measure>, 2 ) <> "-0" && LEFT ( <measure>, 1 ) <> "0"
    )
)

If you find this insightful, please provide a Kudo and accept this as a solution.

[Ahmedx]

try this

IF( ABS([MEASURE])>= 1 ,[MEASURE])

[Ahmedx]

try this

IF( ABS([MEASURE])>= 1 ,[MEASURE])