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
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.