Using greater than '>' to filter a measure in the script or app

[Anonymous]

Hello team,

I'm trying to filter a measure like [Amount]>0, this is not working for me. Please suggest me a workaround.

RaMu

[undergrinder]

Hi Rajes,

in load script your expression is valid.

Load * resident

where Amount>0;

On frontend you can write expression like this:

if(Amounf>0,Amount,null())

then add other functions to sum, count, avg etc...

sum(if(Amounf>0,Amount,null()))

G.