Forum Discussion
PBI does not count items (rows) from list on Sharepoint correctly
It looks like the default aggregation on your ID column is Max. Change it to count or distinctcount in the field well (pull down on the arrow for that column).
Regards,
Pat
Community SupportHi, Libor
It has nothing to do with whether id is unique for each row in your current ‘table visual‘(It needs to take into account all the data in your original table).
You can refer to this document about work with aggregates .
- Count (Not Blanks): Counts the number of values in that field that aren't blank.
- Count (Distinct): Counts the number of different values in that field
Best Regards.
Community Support Team _ Eason
Hi,
thank you for your explaination. Now it is clear.
But have to say, that my problem was in the data itself. We have a one column with allow multiple selection in the sharepoint. In some items are more than one records in this column and after loading these items to the PBI, all of these items were splited to more items based on the number of records in the column with multiple selection. (item with 3 records were splited to 3 items with same ID).
Thank you all for ideas and information.