Forum Discussion
Product Gap Analysis
Its because the measure always returns a result for any combination of customer and company. Either filter the results to only show when the value is Yes or change the measure so that instead of "No" it returns BLANK().
If you need to identify legitimate customers who did not buy the product then you would need to wrap your existing measure inside another IF statement which checks whether the current combination of company and customer is valid.
Super UserIts because the measure always returns a result for any combination of customer and company. Either filter the results to only show when the value is Yes or change the measure so that instead of "No" it returns BLANK().
If you need to identify legitimate customers who did not buy the product then you would need to wrap your existing measure inside another IF statement which checks whether the current combination of company and customer is valid.