wanna Convert -100.00% to Blank

[Chanleakna123]

Hi , i use above measure , and put in table , 

i wanna convert from -100.00% to o , can i ? 

[v-juanli-msft]

Hi @Chanleakna123 

Measure below:

MEASURE =
VAR D1 = ( [Y_2021] / [Y-2019] ) ^ ( 1 / 2 ) - 1
RETURN
    IF ( ISERROR ( D1 ), 0, IF ( D1 = -1, 0, D1 ) )

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Chanleakna123]

@v-juanli-msft @tex628 @amitchandak  , all are work out , thanks you so much ^^

[tex628]

Try this, 

Measure = 
VAR Value = DIVIDE( [Y_2021] , [Y_2019] , BLANK())
Check = IF( Value = BLANK() , BLANK() , (Value^(1/2))-1
Return 
Check

[Chanleakna123]

@tex628 it's red as below . 

[tex628]

Sorry, i was a little to quick! 

Measure = 
VAR Val = DIVIDE( [Y_2021] , [Y_2021] , BLANK())
VAR Check = IF( Val = BLANK() , BLANK() , (Value^(1/2))-1 )
Return 
Check

/J

[Chanleakna123]

here , still error

[amitchandak]

@Chanleakna123 , you have val in your formula, not value?

[tex628]

I was the one that messed up the DAX 🙂

/ J

[tex628 · Accepted solution]

3rd time's the charm!

Measure = 
VAR Val = DIVIDE( [Y_2021] , [Y_2021] , BLANK())
VAR Check = IF( Val = BLANK() , BLANK() , (Val^(1/2))-1 )
Return 
Check