Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
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 :-))
Solved! Go to 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |