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,

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.