Forum Discussion
Matrix custom Column Total
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?
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/1354591
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/963588#M428vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc
2 Replies
- amitchandak
Super User
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/1354591
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/963588#M428vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc - visheshjain
Impactful Individual
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