How to modify the YTD GP% expression , so that it will return GP < 20% ?

[admin11]

Hi All

I have below expression working fine :-

GP% YTD = DIVIDE(([Sales YTD] - [COST YTD]),[Sales YTD])

May i know how to modify the expression , So that it will return only those 3 row where GP less then 20%

Paul

[amitchandak · Accepted solution]

@admin11 , Try a measure like

GP% YTD =
var _1 = DIVIDE(([Sales YTD] - [COST YTD]),[Sales YTD])
return
if(_1 <.2 , _1, blank())

[admin11]

@amitchandak 

Thank you very much , it work fine.