Matrix Visual Omitting Values on Expand

[Gandalf12345]

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 number of production Tasks and the Offer Value for the following hierarchy

Order Manager (OM-X)

Production Task (3 Digit)

Machine (on which production task is rendered, TP 2 digit)

OfferNumber

So what you see is that OM-P1 has a total of 3 Tasks with offer value of 203 and OM-P2 has 1 Task with Task number 110 and Machine 10 but no offers. That is correct so far.

If I now click on one of the red highlighted expand buttons, the matrix visual immediately changes and ommits OM-P2 and Task 112 for OM-P1.

I assume this has to do with the fact that 112 and 110 do not have an offer.

But why does the visual behave like that and how can I change it so that it does not ommit the lines? I mean the Totals are correct but they do not match the sum of the individual lines (for #Tasks). That does not seem to make sense.

Thank you and kind regards

Gandalf12345

[danextian]

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]

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