Summary row data & scorecard counted numbers differently? Data discrepancy

[MarcusdeMan]

Hi all,

I have an issue or a misunderstanding in how summary data is being calculated.

Here is the setup:

1. Heat map table showing monthly total users
2. Scorecard showing the total users over the year

When adding the total users per month by hand the amount is different than the summary row calculated in the heat map table. Similarly, the number in the scorecard reflects the calculation from the summary row. 

A colleague told me that it is because Looker studio calculates distinct "total users". Is that the reason?

If so, how can this be circumvented to NOT use distinct "feature?"

[sam8 · Accepted solution]

It sounds like your understanding is correct. The scorecard should match the summary row because both are the true number of distinct users over the time period.

If the summary row added all of the row values together, it would double-count users. The summary row would end up being much larger than the scorecard, and would be duplicating data. Is that what you're trying to achieve?