Missing dimension measures are commonly used in churn and exception reporting and analyses. For example, a report may be needed which displays the specific products that haven't sold or the past customers who haven't made a purchase in a given filter context. Additionally, missing dimension measures give greater meaning to other dimension measures. For instance, the count of products sold in a period may not be as useful without knowing how many products were not sold over this same period.
The following DAX measure counts the number of unique customers without Internet Sales history:
Internet Sales Customers Missing = CALCULATE(DISTINCTCOUNT('Customer'[Customer Alternate Key]), FILTER(VALUES('Customer'[Customer Alternate ...
