- The selections applied in the Analytics pane result in new expressions added to the DAX query of the visual:
A SQL Server profile trace of a Power BI Desktop file using the Analytics pane for Min, Max, and Average
- The analytics calculations are translated into the equivalent DAX expressions (ie MINX(), AVERAGEX()) and passed into the GROUPBY() table function.
Running a SQL Server Profiler trace against a Power BI Desktop file and viewing the full DAX query associated with a given visual (including all filters applied) is a great way to understand advanced DAX functions and filter context. In Windows Task Manager, ...