DISTINCT MEASURE

Hi Ashish_Mathur,

Thank you for the pbi file.  I noticed that there is no measure for the 'Customers Who Bought'

Also, the table that can be created from the pbi file still cannot achieve the scenarios as outlined BASED on number of customers.

Assuming the total number of active customers (active means who bought) = 67

Selection A:

If the dropdown filters for Product and Salesperson is default as ALL, then the 4 table columns must be (result):

ASSIGNED TO SALESPERSON = 67

CUSTOMERS WHO BOUGHT = 67

OVERALL ACTIVE CUSTOMERS = 67

OVERALL CUSTOMERS WHO BOUGHT = 67

Selection B:

A product is selected and only 6 customers bought this product.  These 6 customers are all assigned to Salesperson #10 who has 10 assigned customers. The resulting table must be:

ASSIGNED TO SALESPERSON = 10

CUSTOMERS WHO BOUGHT = 6

OVERALL ACTIVE CUSTOMERS = 67

OVERALL CUSTOMERS WHO BOUGHT = 6

The ultimate goal is basically to get the ratio between

1. How many CUSTOMERS WHO BOUGHT vs how many CUSTOMERS ASSIGNED TO A

SALESPERSON

2.  How many OVERALL CUSTOMERS WHO BOUGHT vs how many TOTAL ACTIVE CUSTOMERS

Thanks agian.