Parent - Child hierarchy in same row

Hi nbitabc 
There are 2 things that you have to deal with:

1. The challenge is to get a region as a sub-total.

For this purpose, you need to create a table with all the cities and their origins.

I have an example with the same logic with customer segments so my table is :

The order column is for sorting them at the right order Regions always should be first.

This table should be related to your country table (for this scenario many to many it's ok )

That's it you can use it in the matrix :

The second thing you need the measures will be on rows :

This is just  a switch from format values :

Pbix with my example is attached, you can follow my steps

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