Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

measure as visual filter slows down calculation

Hello Team,

 

I have a table with some dimension and 5 measures across this dimension:

Measures 1,2 and 5 are very simple - just sum and count

3 and 4 are more complicated yet still in given selection whole visual is loading within a 3-4 sec

 

Now my goal is to show only results for which "measure 5">1, so I am putting this measure as a filter on visual and my visual starts go crazy and is loading within 20+ sec

 

I can't figure out what making this issue, I would expect more or les the same 3-4 sec

 

Any suggestions why is that happening?

Thank you!

 

 

 

Need Help

2 Replies

  • v-jingzhang's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support
    3 years ago

    Hi Anonymous 

     

    Please try adding the following measure and add it to the filter pane. Set it to show items when value is 1. See if it will perform faster. 

    Flag Measure = IF([Measure 5]>1,1,0)

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi v-jingzhang

       

      thanks for reply,

      No improvement, this works the same as with [Measure 5] > 1 on filter pane

       

      Best