Return difference values between two DAX measures

[Nisham]

Hi. I have a requirement where I need to compare 2 measures and show the result when filtered to a Date.Month. Both the measures calculates distinct customers. 

Measure - 1

Dist. Cust. All = Calculate(DISTINCTCOUNT(Sales[Customer No_]),REMOVEFILTERS('Date Table'[Month Name]))

Measure - 2

Dist. Cust. = DISTINCTCOUNT(Sales[Customer No_])

Need the results as follows: Assuming Date.Month filter is ON. 

Measure - 1      Measure - 2          Result

     A                      B                         A

     B                      D                         C

     C

     D

[Ashish_Mathur]

Hi,

Your question is not clear.  To your slicerfilter/any visual, drag any date filed from the Date Table only.  Does this measure work?

Measure 3 = [Dist. Cust. All]-[Dist. Cust.]

If it does not, then share some data to work with, describe the question and show the expected result.

[Nisham]

Hello Ashish,

Thanks for your response. 

Both measures below calculates a distinct count of Customers from the same sales table. 

Measure - 1 (M1)

Distinct Customers ALL = Calculate(DISTINCTCOUNT(Sales[Customer]),

REMOVEFILTERS('Date Table'[Month Name]))

Measure - 2 (M2)

Distant Customers = DISTINCTCOUNT(Sales[Customer No_])

Basically I need to compare (M1) and (M2) and return the list of customers which do not appear in (M2) when filtered to a specific period. 

[Ashish_Mathur]

Hi,

Share some data to work (in a format that can be pasted in an MS Excel file) with and show the expected result.