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