How it works...

For this recipe, we assume that the organization's Total Annual Revenue, Total Annual Cost, and Employee Overhead Cost Factor are all known values. The Total Annual Revenue measure represents the total amount of revenue earned during the year under analysis. Similarly, the Total Annual Cost measure represents the total of all costs to the organization, including employee costs. The Employee Overhead Cost Factor measure represents the multiplier by which employee annual salaries are adjusted to account for employee benefits such as health care.

The next data point we need is the amount of revenue earned by the organization during the time period under analysis. This is the purpose of the Revenue measure. While the actual revenue ...

Get DAX Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.