Matrix vs Column Chart measure behavior: measure total versus grand total

[kadlecb1]

Matrix vs Column Chart: measure behavior - measure total versus grand total

In checking the other threads I was hoping would have a direct answer, this seems to be just different enough to warrant a post. Sorry if it's not.

I think I understand why this is happening (an on-the-fly calculation of values in the column chart), but am looking to display the data shown in the matrix. Am I missing a super-obvious way to get what I'm expecting without adding another measure to my model?

Thanks all! 

[kadlecb1 · Accepted solution]

Thanks!

While that does provide the correct number, the result feels a little less intuitive.

I think this may just be a case of an imperfect match between haves and wants.

Happy to mark it as solved, but if anyone else knows of a different visual that represents the same concept, I'm all ears.

[vojtechsima]

@kadlecb1 ,

Well, you can play with it, you can set up the secondary Y axis with zeroes aligned, so it's gonna be always on top, or even set up dynamix Max, so it's slightly above,  and play with the line and data labels, so it feels natural.

Kudos appreciated.

[vojtechsima]

Hey, @kadlecb1 ,

I assume you use the automatic Total in the column chart will sum up whetever values you will have there and give you that result.

Total in matrix is not Total as normal sum, but it's the same calculation without the column (in your case) context.

If you wanna display the correct Total above, you can create Combo Chart and add Total as the Line for example and then stylize it to fit your needs.