Matrix count does not match Table Data

Hi Chopacabura 

Thanks for reaching out on the Microsoft Fabric Community Forum.

In Power BI where the Matrix visual count didn’t match the Table visual when grouping by “Days Late” into buckets like OVRD, 0–30, 31–60, and 61–90.

The logic I used in my case, the matrix was overcounting rows, for example, showing 7x OVRD and 9x 0–30, even though the actual table only had 3 and 4 respectively under the same filters.
I faced same issue is, to group Days Late into buckets (like 0–30, 31–60, etc.) didn’t exclude overlaps properly. So
one record could accidentally fall into multiple buckets, inflating the Matrix totals.

Use explicit range logic with both lower and upper bounds. Refer bellow Measure. I just given dax by seniario based.

Category Test  = SWITCH(TRUE(),

    'Table'[Days Late] > 90, "OVRD",

    'Table'[Days Late] >= 61 && 'Table'[Days Late] <= 90, "61-90",

    'Table'[Days Late] >= 31 && 'Table'[Days Late] <= 60, "31-60",

    'Table'[Days Late] >= 0 && 'Table'[Days Late] <= 30, "0-30",

    "Other")

This makes sure each row falls into only one category, with no overlap, so your Matrix will now show accurate counts that exactly match your Table.

--------------------------------------------------------------------------------------------------------------------------
If this solution works for you, please consider marking it as accepted so others facing a similar issue can benefit too.

Regards,
Akhil.