Hi @dixerio
I checked with the sample data and found that if the measures have identical values across dimensions, the Table visual type does not show the count of repeating values, whereas the Pivot table does. This could be the reason for the discrepancies. Please try using the Pivot visual type and verify if any records are excluded when exporting the results to Excel.
Example: Please refer to the following image for reference. Building A has 10 values, consisting of 8 unique values and 2 same values. In the Table visual type, when the measure field is added to the ROW section, its showing the repeated values once. However, when the same measure is added to the VALUE section, the average is aggregated correctly.
If you still need any further help. Please recreate this issue in Arena using sample non-sensitive data, I can take a deeper look to see what is going on.