Problem  Calculation Expression 

Total Sales Calculation  Calculated measure using SUM to aggregate a column. 
Total Cost Calculation  Calculated measure using SUM to aggregate a column.

Profit Calculation  Calculated measure using two previously created calculated measures to determine profit.

Profit Margin  Calculated measure using two previously created calculated measures to determine profit margin, the DIVIDE function is used to perform the division.

Transaction Count  Calculated measure that returns a count of all rows in a table, ultimately, many times this simple calculation is used to return transaction counts. 
Related Table Count  Returns the total rows in a related table. For example, total transactions by Product. 
Problem  Calculation Expression 

MTD Sales  Calculates Total Sales for all days in the current month up to the maximum day in the selection. 
MTD Sales (Direct Query)  Calculates Total Sales for all days in the current month up to the maximum day in the selection.

Problem  Calculation Expression 

YTD Sales  Calculates Total Sales for all days in the year up to the maximum day in the selection. 
YTD Sales (Fiscal Calendar)  This calculation uses an optional third parameter specifying the fiscal year end date. 
YTD Sales (Direct Query)  Calculates Total Sales for all days in the year up to the maximum day in the selection.

Problem  Calculation Expression 

Prior Year Profit  
Prior Year Profit (Direct Query)  Calculates Profit for all days in the Year prior to the last year in the selection. Limited to the last day of the selection. 
Year over Year Profit  Calculated measure using two previously created calculated measures to determine YoY profit. 
Last Year YTD Sales  
Total Sales for all Countries  This calculation uses calculate to return all countries in the calculation regardless of the filter context. 
Percent of Total Calculation  This calculation uses two measures previously created to create a percent of total calculation. 
Problem  Calculation Expression 

Rolling 12 Month Sales  Calculated measure that returns a rolling 12 months total for Profit. 
7 Day Moving Average Profit  This calculation generates the daily moving average. The number of days can be changed accordingly. 
Country Rank  Calculated measure to rank a specific column in a table by a measure. In this measure Country from the 