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
hadjigeo's avatar
hadjigeo
Icon for Helper I rankHelper I
6 years ago

Hi v-xicai 

 

thanks for your reply. it needs the same time to load. but what is the +0 at the end doing?

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).

    • v-xicai's avatar
      v-xicai
      Icon for Community Support rankCommunity Support
      6 years ago

      Hi hadjigeo ,

       

      You may try to add "+0" to the end of the original measure formula to reduce the load time.

       

      Best Regards,

      Amy

       

      Community Support Team _ Amy

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.