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
Oros's avatar
Oros
Post Prodigy
3 years ago

Hi MFelix ,

 

Thank you very much for your reply.

 

I think that your solution is very, very close to solve this problem.  Maybe there is something that I am still doing wrong.  Thank you again for your kind help!

 

I have four measures:

ASSIGNED TO SALESPERSON = CALCULATE(DISTINCTCOUNT(Customer_Card[No]),FILTER('SALES TABLE',[Sales]>0))
CUSTOMERS WHO BOUGHT = CALCULATE(DISTINCTCOUNT(SALES TABLE[CUSTOMERS]),FILTER('SALES TABLE',[Sales]>0))
OVERALL ACTIVE CUSTOMERS = CALCULATE(DISTINCTCOUNT(Customer_Card[No]),FILTER('SALES TABLE',[Sales]>0))
OVERALL CUSTOMER WHO BOUGHT = CALCULATE(DISTINCTCOUNT(SALES TABLE[CUSTOMERS]),FILTER('SALES TABLE',[Sales]>0))
 
No matter what the selection is, OVERALL ACTIVE CUSTOMERS column must always stay at 601.
(numbers with check mark or no mark are correct)
 
Selection scenario A:
If NO filter is selected (ITEM or SALESPERSON), the numbers are all correct at 601.

 

Selection scenario B:

IF an item AND a salesperson are selected, all the numbers in the table

change but they are all the same numbers. The 3 cards stay correct.

In the table, only CUSTOMER WHO BOUGHT column is correct for the selection made.

 

 

Selection scenario C: 

IF only all items is selected and a salesperson here is the problem:

 

Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

Hi,

Share the download link of your PBI file.

  • Oros's avatar
    Oros
    Post Prodigy
    3 years ago

    Hi Ashish_Mathur ,

     

    Thank you again for your reply and sorry for the confusion.  I basically need 4 measures (will be as 4 columns) and must follow based on the context (selection).  Here is the summary: