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
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?
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
Will do, thanks for your help.