Adding measures to your Power BI dataset

As a final activity for this chapter, you will add a few basic measures to the Power BI dataset. Measures are not stored on the tables of data but rather during runtime on reports. These measures will be used to do mathematics such as total number of reports, average damage cost amounts, average height of contact calculations, and more. For now, you choose a few basic measures that will give you a starting point for analysis. In future chapters, you can add more measures as you discover new perspectives within the data.

Measures can be added using the DAX expression language, which is a key skill for Power BI. Most of the formulas will be fairly simple for anyone who is familiar with writing formulas in Excel.

Add the following measures in the Data view of Power BI while the Strike Reports Fact table is highlighted:

Name

DAX formula

Description...