Numbers In Charts are Not Corresponding

[kaygee28]

Good Day

I have two charts which do not have similar values in them, one chart determines the number of unique values within three sheets and the other calculates total sales within a period

here are the expressions

Chart that displays total unique values per gender

count(distinct{$<[Contact ID] = >}[Contact ID])

the expression to calculate total sales

Count(DISTINCT{$<[Year Purchased]={"*"}-{'Unknown'},[Month Purchased]={"*"}-{'Unknown'}>}[Contact ID])

they should both display the same number of records since each sale is a record on its own

the first expression pulls 113 records and the second expression pulls 139.

How do I fix this?

Thanks in advance.

[Gysbert_Wassenaar]

Check your data. Perhaps there are records where either Year Purchased or Month Purchased is null or Unknown.

[kaygee28]

Hi Gysbert,

Yes I do have null values in month purchased and year purchased hence I excluded them in both my expressions.

Thanks in advance, but I reckon both expressions should correlate each other from the looks of things.

Hence I'll just look at my data again.

[Gysbert_Wassenaar]

You do exclude them in your second expression but not in your first. That's why they return different results.

[kaygee28]

I'll have a look at the data and see, but it still doesn't make sense at the moment.

Thanks a lot for your help!!