Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hello
I have a table where the visual is running pretty slow. Looking into Performance Analyser, i noticed the DAX query MS duration is 14506 and other is 513.
Wondering if you could help to bring the duration lower:
Here is the dax code copied from performance analyser:
thanks
Viral
Solved! Go to Solution.
to know which measures are affecting the performance,
you can create a table per each measure and check from the performance analyser , each visual how much its dax code it taking.
this way we can filter out all measures that are dont affect performance. .
can you please do it, to know which measures needs improvements ( if the improvement is possible )
please provide some context of the measure. like what does the measure do ? how are you using it ?
etc...
How to provide sample data in the Power BI Forum
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
How to Get Your Question Answered Quickly
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
@Daniel29195 Apologies, here is the result acheived with the measures used:
to know which measures are affecting the performance,
you can create a table per each measure and check from the performance analyser , each visual how much its dax code it taking.
this way we can filter out all measures that are dont affect performance. .
can you please do it, to know which measures needs improvements ( if the improvement is possible )
Thanks for the quick response:
Here is the results:
LastM Dax 801
Last M Ranking Dax: 903ms
Mom Ranking 1 Dax: 2313ms
Last Quar Ranking Vol Dax: 447ms
Last Quar ranking Dax: 730ms
QoQ Ranking (Fixed) Dax 918ms
User | Count |
---|---|
84 | |
81 | |
65 | |
52 | |
46 |
User | Count |
---|---|
100 | |
48 | |
42 | |
39 | |
38 |