Forum Discussion
AbhinavJoshi
Responsive Resident
Responsive ResidentWrong Total in Table
Hello All, I recently changed by data soource from Excel to SQL Datbase. I have both the table visuallization, and thier data is same. However, my total at the end of table comes to be wrong. An...
danextian
Super User
Super UserHi AbhinavJoshi ,
Did you use DISTINCTCOUNT or a similar function or reference a measure that uses this function? If so, that behaviour is expected. To illustrate, the unique count of [Item] per [Category] is 1 for each but in total there are only two unique items which are 0001 and 0002
| Category | Item |
| A | 0001 |
| B | 0001 |
| C | 0001 |
| D | 0002 |