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=1739302493-F8JZQnAxcaGM8lmY1MNIqSBUZb2Ql88x-0-e31de2c82d1bb7e06dcff751b4bf8391)
Figure 16- Completed example with both of the new measures