CountRows Returns Six Should Only Be Five

Hi tecumseh ,

Do you mean that you have six rows in your data, but the table visual only shows five rows? Check for duplicate rows, which may be caused by PowerBI automatically ignoring duplicate rows when fields are placed. You can solve this problem by adding the index column.

For example. You can hide it by adjusting the background color and font color of the index column or manually adjusting the column width.

If I don't understand correctly, please provide some sample data and screenshots that will help me reproduce the problem and provide a solution.

Best regards,

Mengmeng Li