Forum Discussion
Count function not counting correctly
Another good test is rather than using the operator field as the first column (which we know is from another table), use the "Name" field from the last screenshot you posted, as it's in the same table. I understand the formatting is not nice, but let's just see if the count works properly.
If it counts to 19 for Tomasz, then the problem is with your relationship between your tables. If it counts to 99 for Tomasz, then the problem is that you are expecting the wrong result (i.e. with the filters you have applied, 99 is actually the correct answer - maybe your date slicer isn't related to your data correctly).
The relationships can be viewed in the Model view (the last of the 3 buttons in your left pane).
The filters being applied to your table can be viewed by hovering over the Filter Header Icon in the top right of your table-visual - this will include which slicers are impacting on the table.
Resolver IAnother good test is rather than using the operator field as the first column (which we know is from another table), use the "Name" field from the last screenshot you posted, as it's in the same table. I understand the formatting is not nice, but let's just see if the count works properly.
If it counts to 19 for Tomasz, then the problem is with your relationship between your tables. If it counts to 99 for Tomasz, then the problem is that you are expecting the wrong result (i.e. with the filters you have applied, 99 is actually the correct answer - maybe your date slicer isn't related to your data correctly).
The relationships can be viewed in the Model view (the last of the 3 buttons in your left pane).
The filters being applied to your table can be viewed by hovering over the Filter Header Icon in the top right of your table-visual - this will include which slicers are impacting on the table.