Forum Discussion
Distinct Measure producing incorrect results
HI Anonymous,
Dax formulas will use 'AND' logic to link all filter conditions, I think you need to double-check on your table to confirm all of the records are matched with 'win7'/'win10' conditions. Or they will exist some of not match records that different than 'measure 1' results.
In addition, the sum of 'distinct count' results may not the same as the 'distinct count' of aggregate results. Some of the items existed in different conditions but they not auto remove from the calculated in the aggregate level.
For example:
distinct count 'formula 1' with conditions 1: ABCD -> 4.
distinct count 'formula 2' with conditions 2: ACE -> 3.
distinct count 'formula 3' with conditions 3(1 or 2) : ABCDE -> 5 ≠ 7(formula 1+formula 2)Regards,
Xiaoxin Sheng
HI Anonymous,
Dax formulas will use 'AND' logic to link all filter conditions, I think you need to double-check on your table to confirm all of the records are matched with 'win7'/'win10' conditions. Or they will exist some of not match records that different than 'measure 1' results.
In addition, the sum of 'distinct count' results may not the same as the 'distinct count' of aggregate results. Some of the items existed in different conditions but they not auto remove from the calculated in the aggregate level.
For example:
distinct count 'formula 1' with conditions 1: ABCD -> 4.
distinct count 'formula 2' with conditions 2: ACE -> 3.
distinct count 'formula 3' with conditions 3(1 or 2) : ABCDE -> 5 ≠ 7(formula 1+formula 2)
Regards,
Xiaoxin Sheng