Forum Discussion
Incorrect Total in Matrix Visual
I've seen this kind of behaviour but that was a simple solution. That was of typing mistake. But this is completely different. I am not certain about the issue. I won't be able to help without seeing any data, but guess it's not possible.
best of luck. Let us know here if you find the root cause.
BR,
Rubayat
Ensure 'Cases'[Case Length (Validation Date)] values for Adjudication are indeed in the 6-9 months range.
Ensure Adjudication cases are marked as "Resolved" and their 'Cases'[Resolution Date] falls within the current fiscal year.
Make sure no filters exclude the 6-9 months Adjudication cases from your visualization.
Confirm the missing Adjudication cases are in your dataset and don't have anomalies.
Review relationships to ensure no inadvertent filtering.
I've carried out checks 1-3 that you suggested and they are fine. Additionally, I have isolated the 78 6-9 mths in the data table by applying filters to relevant columns.
So I'm not quite sure why there are 53 Adjudications (6-9mths) being included in the matrix? They are not being counted in the row & column totals, which I believe is a good thing.They shouldn't be in the visual from what I can see, I'm at a loss why they are there.
Can you provide additional demo data or pbix file?
Unfortunately I cannot provide a pbix file as its directly connected to large complex live system.
Would you agree that the measure I have provided should in no way introduce 'phantom' numbers into my visual, bearing in mind that the report is filter free? The 53 was excluded in the totals which is even more bizarre.
As I've mentioned already, I have duplicated the report and re-built it using filters and distinct counts I it works, the red circle below is now correct as a blank.
Have you seen behaviour like this before?
