Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Using measure as filter causes visualisation to hang

Hello,   I have a measure in a visualisation filter, so that I can select only records that are in a date range (selected in a slicer) (i.e. count = 1). The measure uses USERELATIONSHIP to link the...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago
You can see that the date filter is picked up and although referenced in SUMMARIZECOLUMNS isn't reducing the row set at all. Everything gets computed for every row and then at the end that table only keeps rows with [Measure] = 1.

 Thanks bcdobbs but why doesn't that logic hold for the unfiltered table where the rows are sorted by the measure? It generates quickly in that situation, but doesn't it have to calculate every row just as you mention above for the filter?

 

Thanks

bcdobbs's avatar
bcdobbs
Icon for Community Champion rankCommunity Champion
4 years ago

You're right certainly not answered yet!

 

Can you share the full query that the performance analyser when the matrix hangs? 

Does it hang when you just have the filter measure or do you only get the issue when you have everything in?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Can you share the full query that the performance analyser when the matrix hangs? 

    The "Copy query" button in performance analyzer is ghosted out, a bit frustrating as it must know the query that it is trying to run??

     

    Does it hang when you just have the filter measure or do you only get the issue when you have everything in?

    It only hangs when I have everything in. If I just have the filter measure (and a fact table field) then it's runs quickly.

    • bcdobbs's avatar
      bcdobbs
      Icon for Community Champion rankCommunity Champion
      4 years ago

      Something odd there! Can you share the code for each measure. Running out of ideas but that might at least spark a line of enquiry!