Matrix table giving different values vs using Regular table

Hi, Nepal101 

According to your description, when using the matrix, the error value is displayed and according to the test, everything is fine on this side. You can try the following to troubleshoot the error.

1. The matrix may be grouping data into rows or columns, which, if the grouping is not intentional, can cause values to be displayed incorrectly. Check to see if there are any additional fields in the Rows or Columns section that may affect the display of the data.

2. Verify that there are no filters or slicers applied to the Matrix that are not applied to the table visual object. These filters can be page-level, report-level, or visual object-level filters.

3. Data Model Relationships to ensure that all relationships in the data model are configured correctly. Incorrect relationships can lead to unexpected results for visual objects that depend on the data in question.

If this does not work, you can share the pbix file without sensitive data or any data that replicates this problem.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum