Microsoft Power BI Complete Reference
上QQ阅读APP看书,第一时间看更新

Total Sales

To create your first measure, select the Internet Sales table and then click New Measure... from the modeling ribbon. In the formula bar, type the following code and hit Enter:

Total Sales = SUM('Internet Sales'[Sales Amount])

One of the benefits of creating explicit measures is the ability to centralize formatting. Once the measure has been created, navigate to the modeling ribbon and change the formatting to $ English (United States), as shown in the following screenshot:

Figure 11-Change formatting to $ English(United States)