![Microsoft Power BI Complete Reference](https://wfqqreader-1252317822.image.myqcloud.com/cover/84/36699084/b_36699084.jpg)
上QQ阅读APP看书,第一时间看更新
Percentage of total calculation
Now, create another calculated measure on the Internet Sales table using the following code. Make sure that you format the measure as a percentage:
% of All Countries = DIVIDE([Total Sales], [Total Sales all Countries])
In the following screenshot, you can see the completed example with both of the new measures created in this section. Without a basic understanding of the CALCULATE function, this type of percent of total calculation would be nearly impossible:
![](https://epubservercos.yuewen.com/644FAD/19470384001518306/epubprivate/OEBPS/Images/49c48d45-17ca-4b99-ab56-9ddd4f6d4eb7.png?sign=1739369882-ivsK7dmD94tqFnUDKUpS40c2pqUI5pdf-0-2bced96b190bff4eeec236b3d135d635)
Figure 16- Completed example with both of the new measures