Calculating a Proper Denominator Count
Suppose you want to calculate the average sales per customer. Logically, that just means dividing the Sales Amount by the number of customers.
A Simple—but wrong—Calculation
To get the number of customers, you can use the Count function. The following MDX query gives what, at first glance, seems to be the correct answer:
Tags: mdx