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: 

Figure 16- Completed example with both of the new measures
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.216.232.11