Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Matrix Total incorrect - Need Help

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-Polisnum...
"Need Help"
@ Matrix Visualisation Error In Calculation
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    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. 

FreemanZ's avatar
FreemanZ
Super User
3 years ago

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. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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?