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-Polisnummer]))


Any idea why the totals are incorrect?

With kind regards,

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

3 Replies

  • 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?

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Another example: