Forum Discussion
Return difference values between two DAX measures
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
3 Replies
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.
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.
Hi,
Share some data to work (in a format that can be pasted in an MS Excel file) with and show the expected result.
