Forum Discussion

Gandalf12345's avatar
Gandalf12345
Advocate I
2 years ago

Matrix Visual Omitting Values on Expand

Dear Community, haven't posted anythnig till now, yet but your posts have already helped me a lot. No I have something that I cannot find an answer for. I try to build a matrix visual Showin the n...
Need Help
danextian's avatar
danextian
Super User
2 years ago

Hi Gandalf12345

What does the measure in your visual do? If it counts the distinct values of something then the total many not match the  sum of individual rows as the distinct count is evaluated for each unique item in a column while for total it is for the whole of the column.  In the illustration below, you'll see that for A, B and C  each has 1 unique item while  D has 2.  3 x 1 + 2  = 5 but as whole there's are only three unique items.

 

  • Gandalf12345's avatar
    Gandalf12345
    Advocate I
    2 years ago

    Hi danextian,

    thanks for jumping in.

    The visual has

    • a normal count (not a distinct count) on the "Worktask" calculated column (with the "Worktask" column containing unique values only) and
    • a Sum on the Offer Value which is in a separate table that holds all offers and is connected 1:n via the Worktask ID.

    The Model looks like that:

     

    I have seen that in my lazyness I used implicit measures, which may form part of the problem, as well, because it disappears if I use an explicit measure using sum.

    However, then, I get a completely flawed matrix on the # of Worktasks

    Can you kindly shed some light what am I doing wrong and especially

    1. why is the visual behaving so stange with implicit values and

    2. what might be the problem with the explicit measure?

     

    Best regards,

    Gandalf12345