Matrix custom Column Total

[dw700d]

I would like to incorporate the visual below into a Matrix. This visual shows taxes paid by different groups. Within the matrix I would like to place location in the column section of the matrix. The matrix columns would show “World”, “U.S” and “International”. The challenge is, “World" is not an actual column in my data set. The world column is just the combination of the U.S and International columns added together. Is there a way to create measure that allows me to add a "World" column to the matrix at the same hierarchical level as U.S and international?

[visheshjain]

Hi @dw700d ,

Have you tried using 'Calculation Groups'?

You can define a calculation group which will have 3 values U.S., World and International.

In calculation for the US and International, you can provide a filter in the measure and for World, since is it just the sum of US and International you don't need to provide the filters.

Hope this helps.

Thank you,

Vishesh Jain

[amitchandak · Accepted solution]

@dw700d , If US and international are rows values in column, then World is like grand total, You will get that as Grand total in matrix.

Otherwise all of them need to me measures

OR consider Hybrid table workarounds

if you are looking for a Hybrid display with Matrix Column and measure
https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1...
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/...

vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc