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
MFelix's avatar
MFelix
Super User
3 years ago

Hi Oros ,

 

This is related with the way you are filtering the measure, since you are doing a FILTER(SALES TABLE, ,[Sales]>0) this is returning the filter for the current selection and you are not overcoming the filter context in this case try the following code:

TOTAL ASSIGNED CUSTOMERS (EXCLUDING NO SALES)  = CALCULATE(DISTINCTCOUNT(Customer[No]),FILTER(ALL('SALES TABLE'),[Sales]>0))
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:

       

       

  • MFelix's avatar
    MFelix
    Super User
    3 years ago

    Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

    If the information is sensitive please share it trough private message.