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 = Calc...
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.