Forum Discussion
Using measure as filter causes visualisation to hang
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.
Hi Anonymous ,
You can try importing performance analyzer data in dax studio, simplifying the analysis of slower queries in a report.
https://www.sqlbi.com/articles/importing-performance-analyzer-data-in-dax-studio/
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.