In this tutorial, you’ll learn how to use the Query Builder feature to easily create queries and measures in DAX Studio. You can access this by clicking on the Query Builder option found in the Home tab. This opens a new pane where you can specify columns, measures, and filters to create a query. To
In this tutorial, you’ll learn how to evaluate a DAX code’s performance using the Run Benchmark option in DAX Studio. The Run Benchmark option allows you to customize the number of cold and warm cache executions in your query. When you click this option, the Benchmark wizard opens. You can specify the number of times
In this tutorial, you’ll learn how the Performance Analyzer works in Power BI. Specifically, this blog will discuss the query generated by the Performance Analyzer tool and how it changes depending on the visuals in your report. Performance Analyzer is a Power BI tool that measures and displays the duration required for loading or refreshing
In this tutorial, you’ll learn about Query Plan and Server Timings in DAX Studio. This is an overview of what happens behind the scenes whenever you run a DAX query. You can find the Query Plan and Server Timings option in the Traces pane under the Home tab. Query Plan In DAX Studio When you
In this tutorial, you’ll learn how to visualize the filter context in Power BI DAX Studio. Specifically, you’ll learn how to enable tooltips that show the active filter context of any cell in a table or matrix. A filter context reflects any active filter on a currently selected cell in Power BI. When you right-click
