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
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!