Forum Discussion

Oros's avatar
Oros
Post Prodigy
3 years ago

DISTINCT MEASURE

I have the following measures that separately shows in a card as follow.  The TOTAL ASSIGNED CUSTOMERS (EXCLUDING NO SALES) keeps on changing to the same value as the DISTINCT CUSTOMERS COLUMN.  Ther...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

Hi,

I just cannot understand your requirement.  See if this revised file helps.

Oros's avatar
Oros
Post Prodigy
3 years ago

Hello Ashish_Mathur ,

 

I think that the confusion was on the 'ASSIGNED TO SALESPERSONS'.  This should mean how many customers are assigned to each or all salesperons (NOT who is the salesperson assigned).

 

Here is the context of the report that requires 4 columns.  Thank you for your patience and help.