Matrix count does not match Table Data

[Chopacabura]

Hi, 

My total count for this one category is not counting the total numbers being shown in table detail.  "Days Late" is what I am trying to capture in Matrix but its showing the correct number in table when selected but I am not sure what is counting.

This example should show 3x OVRD and 4x 0-30 but 61-90 show correct quantity.  All the other category is showing the correct matching quantity but this one category is acting up.  What could it be the cause?

This should show 3x OVRD and 4x 0-30 and 61-90 is showing correct count (Days Late)

This is next category that works but above category is the only matrix that is reading something else.

What could be the cause?  There is no duplicate in my category reference, its one to many relationship.

[v-agajavelly · Accepted solution]

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.