Quick measures Quick measures are a capability that allows you to use a drag-and-drop interface to quickly create measures with a minimal amount of code. Quick measures are a great way to not only easily create measures but also learn DAX. You can look at…
Scatter chart – Creating Reports
Scatter chart A scatter chart is a visual that plots many data points using an x and y axis for typically two categories or variables that you select. Scatter charts are the same as scatter plots, which are often used in statistics for visualizing data….
Step diagnostics – Optimizing Model Performance
Step diagnostics To generate step diagnostics tables, select the step under Applied Steps of the Query Settings pane in Power Query. Then, click Diagnose Step under the Tools tab of the ribbon. Once the diagnostics have executed, you’ll see new diagnostic tables created for just…
Optimizing relationships – Optimizing Model Performance
Optimizing relationships When report visuals are configured with fields from multiple queries or tables and expected results are not seen, then it’s possible there are issues with the relationships that have been set up (or autoconfigured by Power BI). When optimizing relationships, it’s important to…
Creating semi-additive measures – Creating Measures Using DAX
Creating semi-additive measures Power BI has three different types of measures it can perform: additive, non-additive, and semi-additive. We will check each of them out in the following sections. Additive measures An additive measure, such as sum, aggregates over an element. Our gross profit calculations…
Optimizing data in the model – Optimizing Model Performance
Optimizing data in the model We’ve covered, in previous chapters, how Power BI supports directly connecting to a data store, such as connecting to an Enterprise Data Warehouse (EDW) that has billions of records and years of sales history. When configured with DirectQuery performance, Power…
Splitting numeric and text column data – Optimizing Model Performance
Splitting numeric and text column data In the VertiPaq engine, data is stored in a columnar data format. This means for a given query or table, each column is given a data type and all records for each column are stored independently from each other,…