Same values in visualizations but different totals for quarterly and monthly

[DM19]

I have two visualizations with the same inputs, but the quarterly totals do not match up with the three month totals. The three month totals are much higher than the quarterly number. The value field is a distinct count with a yearly legend and monthly/quarterly axis.

Looking at the first quarter and January to March of 2017, The quarterly total is 123K and the Jan-Mar total is 143K, but if I drill up or down on either of them, I get the same graph. Has anybody run into this problem? 

[Vvelarde · Accepted solution]

@DM19

Hi, The key of the difference is The Distinct Count.

In one Chart the distinct count is by Quarter and the other is by month.

The results are correct.

[DM19]

Thanks for the help!