Forum Discussion

hadjigeo's avatar
hadjigeo
Icon for Helper I rankHelper I
6 years ago

when adding a filter on Page the visual is loading for 1-2 minutes .

Hi,   i have the below visual and when i add a filter to remove the rows that have 0 on Sales 150% and GPM150%   I have created this measure : if ( and ( Sales150% =0,GPM150% =0),0,1). i add this...
Need Help
TCarrasquillo's avatar
TCarrasquillo
Icon for Helper II rankHelper II
6 years ago

Hi,

 

You should be able to do this in the filter pane without a measure. Just turn on advanced filtering (or it might be on as default) for each column and then you can pick show items when the value: is not 0.

 

hadjigeo's avatar
hadjigeo
Icon for Helper I rankHelper I
6 years ago

Hi,

TCarrasquillo 

 

but how can you do the and?

 

if ( and ( Sales150% =0,GPM150% =0),0,1).