Matrix Total incorrect - Need Help

Anonymous — Tue, 07 Feb 2023 09:11:02 GMT

Hey guys,

I have this Matrix calculating the totals.
I use the following formula to calculate my values:

Polissen = CALCULATE(DISTINCTCOUNT('Union Maia Data'[cldeeln.Naw.Naw-Polisnummer]))

Any idea why the totals are incorrect?

With kind regards,

Lazzanova

Re: Matrix Total incorrect - Need Help

FreemanZ — Tue, 07 Feb 2023 09:13:55 GMT

hi Anonymous

it is because one item "cldeeln.Naw.Naw-Polisnummer" could present at multiple categories.

If you change DISTINCTCOUNT to COUNT, the total will be correct, even it might not be your expected result.

Re: Matrix Total incorrect - Need Help

Anonymous — Tue, 07 Feb 2023 09:15:27 GMT

Another example:

Re: Matrix Total incorrect - Need Help

Anonymous — Tue, 07 Feb 2023 09:46:03 GMT

Yes, that did the trick.

However I have two visuals here. One showing the correct amount of Totals, the other does not:

Correct Totals:

Incorrect Total:

The measure used at the second matrix for Type E-mail is as follows:

Type E-mail =

SWITCH(TRUE(),

CONTAINSSTRING('Maia Data'[maia.Persoon.e-mail],"onbekend"),"Onbekend",

'Maia Data'[maia.Persoon.e-mail] = BLANK (), "onbekend",

CONTAINSSTRING('Maia Data'[maia.Persoon.e-mail],"sbz"),"Zakelijk",

CONTAINSSTRING('Maia Data'[maia.Persoon.e-mail],"mailstreet"),"Zakelijk",

CONTAINSSTRING('Maia Data'[maia.Persoon.e-mail],"menzis"),"Zakelijk",

CONTAINSSTRING('Maia Data'[maia.Persoon.e-mail],"ntac"),"Zakelijk",

CONTAINSSTRING('Maia Data'[maia.Persoon.e-mail],"onderling"),"Zakelijk",

CONTAINSSTRING('Maia Data'[maia.Persoon.e-mail],"agriver"),"Zakelijk",

CONTAINSSTRING('Maia Data'[maia.Persoon.e-mail],"donatus"),"Zakelijk",

CONTAINSSTRING('Maia Data'[maia.Persoon.e-mail],"ovm"),"Zakelijk",

CONTAINSSTRING('Maia Data'[maia.Persoon.e-mail],"zlm"),"Zakelijk",

CONTAINSSTRING('Maia Data'[maia.Persoon.e-mail],"cz.nl"),"Zakelijk",

CONTAINSSTRING('Maia Data'[maia.Persoon.e-mail],"dsw.nl"),"Zakelijk",

CONTAINSSTRING('Maia Data'[maia.Persoon.e-mail],"zorgenzekerheid"),"Zakelijk",

CONTAINSSTRING('Maia Data'[maia.Persoon.e-mail],"gezondmetsalut"),"Zakelijk",

CONTAINSSTRING('Maia Data'[maia.Persoon.e-mail],"sgv"),"Zakelijk",

CONTAINSSTRING('Maia Data'[maia.Persoon.e-mail],"jtv-zoetermeer"),"Zakelijk",

CONTAINSSTRING('Maia Data'[maia.Persoon.e-mail],"stcdeventer"),"Zakelijk",

CONTAINSSTRING('Maia Data'[maia.Persoon.e-mail],"star-shl"),"Zakelijk",

CONTAINSSTRING('Maia Data'[maia.Persoon.e-mail],"lalarsk"),"Zakelijk",

CONTAINSSTRING('Maia Data'[maia.Persoon.e-mail],"medicinfo"),"Zakelijk",

CONTAINSSTRING('Maia Data'[maia.Persoon.e-mail],"unive"),"Zakelijk",

CONTAINSSTRING('Maia Data'[maia.Persoon.e-mail],"vanderdussen"),"Zakelijk",

CONTAINSSTRING('Maia Data'[maia.Persoon.e-mail],"vecozo"),"Zakelijk",

CONTAINSSTRING('Maia Data'[maia.Persoon.e-mail],"vektis"),"Zakelijk",

CONTAINSSTRING('Maia Data'[maia.Persoon.e-mail],"vgz.nl"),"Zakelijk",

CONTAINSSTRING('Maia Data'[maia.Persoon.e-mail],"zorg"),"Zakelijk",

CONTAINSSTRING('Maia Data'[maia.Persoon.e-mail],"zn.nl"),"Zakelijk",

CONTAINSSTRING('Maia Data'[maia.Persoon.e-mail],"schuldenlab"),"Zakelijk",

CONTAINSSTRING('Maia Data'[maia.Persoon.e-mail],"owmachterhoek.nl"),"Zakelijk",

"Privé")

Does this have to do with the measure? Or something else?

topic Matrix Total incorrect - Need Help in DAX Commands and Tips

Matrix Total incorrect - Need Help

Re: Matrix Total incorrect - Need Help

Re: Matrix Total incorrect - Need Help

Re: Matrix Total incorrect - Need Help