Wrong TOTALS when transform table into stacked bard chart

Hi,

I am running into an issue that total values show differently when changing the chart from Table to Stacked Bar Chart.

Below is the sample data, when it is displayed in Table, it includes:

1. Date
2. # of Appointments on that date
3. Location

Since the column of Appointments/ Day is a measure, which calculates # of appointments that occurred on that specific date of that location. The Total row shows the number of total appointments divided by distinct dates. That is why it shows as 9, instead of 27.

However, when I transform the table view into a stacked bar chart and enable the totals value bottom-- the total number shows incorrectly. (I have less than 20 legends for the stacked bar chart)

I appreciate any thoughts/ comments on this question. Thank you in advance!