Create calculated rows and columns in a matrix

[ashishoza12345]

Hi Folks,

I would like to create a calcuated rows in a matrix visual (Marked in Yellow as shown below)
(1) Country wide

(2) Metropolitan

(3) Regional

And Also the calculated Column "Indoor Games" which is a sum of "Chess", "Carrom" and "TT"

Please find the dataset and pbix file attached

datatset: https://www.dropbox.com/scl/fi/vllxqi98vweufihmx9hke/Game-data.xlsx?dl=0&rlkey=1u37sljq86xat6shd13u6...

pbix file: https://www.dropbox.com/s/yckmxxaccplq7ot/Game%20Stats.pbix?dl=0

[v-chenwuz-msft · Accepted solution]

Hi @ashishoza12345 ,

I recommand you to add a map table for [Area] and create relationship between these two tables.

Result:

Or Create a new group for [Area]

Result:

Pbix in the end you can refer.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PC2790]

Hey @ashishoza12345 ,

From the first look, it seems you have a similar requirement as that of this thread

See if it caters to your requirement.

[ashishoza12345]

Hi @PC2790 ,
Thanks you so much for sharing the tread with me.
How do I create "Indoor games" column in the same matrix? 

[PC2790]

I am not able to access your pbix file and the data.

See if this helps-Creating a “custom” or “hybrid” matrix in PowerBI - Microsoft Power BI Community