The total in a Table isn't calculated correctly

[admin-unidoze]

I don't know if this is a bug or is intended, but assume the following data:

ID	FKColumn
1	ID1
2	ID2
3	ID3
4	ID4
5	ID5
6	ID5
7	ID6
8	ID6

If you put these data in a Power BI Table-control, with:

column1 = ID (Don't summarize)
column2 = FKColumn (Count)
column3 = FKColumn (Count DISTINCT)

Then the automatically generated total for column2 is 8, but for column3 is 6, allthought there are 8 rows with column2 = 1 AND column3 = 1. So the total of a DISTINCT COUNT is not really the sum of all values in the column. (And also an extra remark: I'm unable to rename only column3. When I do this, column2 is renamed also :-))

[v-qiuyu-msft · Accepted solution]

Hi @admin-unidoze, 

In total row for the column3, the count distinct aggregate is performed on the whole FKColumn, so the 6 value displays in total row of column3. 

To get the total value of distinct count for each ID, you can create a measure below: 

Best Regards,
Qiuyun Yu